My common Table Expressions book became available on Amazon.com late last week. After presenting on Common Table Expressions at SQL Saturday yesterday, the sales jumped a bit to the point that the CTE Book is now #2 in the Hot …
My Common Table Expressions book is now available at Amazon.com as both the normal printed book, and the Kindle version. Just in time for SQL Saturday Redmond tomorrow.
My Common Table Expression presentation was accepted for SQL Saturday 212 in Redmond WA. This is the session that I am the most familiar with, and that I have presented the most times. I think this will be the 8th …
Common Table Expression accepted for SQL Saturday 212 in Redmond WA Read more »
Thanks to everyone who attended my CTE presentation at SQL Saturday in Portland Oregon today. Have a great rest of the day. As promised I have posted the slides and sample TSQL queries here. If you have any questions, …
Unleashing Common Table Expressions in SQL Server – Slides and Sample Code Read more »
On the next two Saturdays I will be presenting the Unleashing Common Table Expressions presentation at SQL Saturday 172 in Portland Oregon, and SQL Saturday 166 in Olympia Washington. As part of refreshing the presentation I have added a few …
Here are a few links to some of the other CTE examples used during my Common Table Expressions presentation. Using a CTE in a Function to Split Up a Query String Using a CTE to Split a String Into Rows …
Other SQL Server CTE Material, Posts, and Samples On This Site CTE Hierarchy compared to the alternative Recursive CTE’s Calculating Factorials with a Recursive CTE Fibonacci Sequence CTE – With An Insert Statement Generating a Tree Path with a CTE …
Other SQL Server CTE Material, Posts, and Samples On This Site CTE Hierarchy compared to the alternative Recursive CTE’s Calculating Factorials with a Recursive CTE Fibonacci Sequence CTE – With An Insert Statement Generating a Tree Path with a CTE …
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 everything needed to start using CTE’s for recursive queries, as temporary views, and to use …
The following is Chapter 3 from my Common Table Expressions book it its entirety. CTEs Instead of Derived Tables One time I was handed an eight page print out with an 8pt font showing a single SQL statement. It was …