Improve you query skills Steve’s CTE book!
Over 250 pages of Common Table Expression lessons! Download your FREE copy today! The Common Table Expression (CTE) is one of the more powerful and… Read More »Improve you query skills Steve’s CTE book!
Common Table Expressions
What is a CTE? – Video Explanation
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… Read More »What is a CTE? – Video Explanation
Why Use Common Table Expressions
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… Read More »Why Use Common Table Expressions
It’s CTE Month at Stedman Solutions
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… Read More »It’s CTE Month at Stedman Solutions
What Does CTE Month Mean for You?
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… Read More »What Does CTE Month Mean for You?
SQL Course Coupon Codes
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%… Read More »SQL Course Coupon Codes
Nested CTEs
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… Read More »Nested CTEs
Recursive CTE to Calculate Dates for the Last 30 Days
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… Read More »Recursive CTE to Calculate Dates for the Last 30 Days
Common Expression Tables – Introduction
Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn… Read More »Common Expression Tables – Introduction
CTE Book Sample Code
As part of the CTE book there is a sample database that all the queries use. You can download the create script for that sample… Read More »CTE Book Sample Code