In this short but to the point video Steve explains the question “what is a CTE?” Transcription of this video: CTE is kind of this concept of what we’re calling a virtual table where it’s like a sub query or …
Common table expressions are beneficial to use when writing or managing complex queries. Being condensed or simplified, CTEs increase accessibility and digestion. Watch Steve’s video for more on CTEs…… Transcription of this video: Why would you use common table expressions? …
Hooray! It’s CTE month. Some of you may be happy but you others may by like ugh. Common table expressions can be tough and confusing but WE’VE GOT YOU COVERED! This month we will be throwing lots of valuable CTE …
Ok cool Stedman Solutions is having CTE (common table expressions) month in June. What does that mean for you my reader? Well let me share all the goodies I have to offer this month! Next month I will be releasing……. …
Current Stedman Solutions SQL Course Coupon Codes. Save Up to 65% Off our Popular Online SQL Server Courses, a Once a Year Type Savings! 65% Off for April JOINs Month Coupon Code: APRIL-JOINS Leave your JOIN confusion in the past …
Russian Nesting Dolls If you have ever seen the Matryoshka dolls known as the Russian nesting dolls or babushka dolls they are very interesting. They start with a large wooden doll that when opened contains a slightly smaller doll, then …
Have you ever needed to generate a list of dates for the last 30 days. There are lots of different ways to do this with TSQL, but one way is with a recursive CTE. You can then left join against …
Recursive CTE to Calculate Dates for the Last 30 Days Read more »
I came across this example when preparing my CTE presentation a while back. Which produces the following output. Download my book for FREE when you sign up for my mailing list. Receive your free copy today!
The question came up as to how do I parse a query string using TSQL. So here you go, using a common table expression, and basing this on a similar function to what I put together yesterday for split. which …
Using a CTE in a Function to Split Up a Query String Read more »
After my CTE presentation a while back I was asked many questions, and received several great suggestions from people. One question was how does the performance compare between a recursive CTE to generate a hierarchical tree path listing and …