Last week I had the great opportunity to speak at PASS Summit 2015. My presentation was on Common Table Expressions.   Here is the sample code from the presentation. AdvancedCTEs.zip   Related Links: Common Table Expression (CTE) Month at SteveStedman.com (introduction) …

Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs Read more »

Here is a short video that shows how to convert those ugly derived table (SubQuery) queries into a common table expression to help clean up your TSQL code. This applies to Common Table Expressions on Microsoft SQL Server, and the …

Using a Common Table Expression Instead of a Derived Table Read more »

Today I am at SQL Saturday Portland Oregon, and at 9:00am I am presenting the Introduction To Common Table Expressions session: Here is the abstract: Have you ever wanted to create a recursive query, but didn’t see how to do …

Introduction to CTEs Slides and Sample Queries Read more »

Its going to be a great day!   Ready for SQL Saturday 172 in Portland today, looking forward learning lots, and sharing my CTE Presentation with those who want to learn about Common Table Expressions. Please come to my CTE …

SQL Saturday #172 in Portland Oregon Read more »