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

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)
• Sample Database for Common Table Expressions
• Writing Your First Common Table Expression with SQL Server
• Video: Writing Your First CTE with SQL Server
• Common Table Expressions – Terminating the Previous Statement
• CTE Scope
• Introduction to Recursive CTEs
• Recursive CTE for Dates In A Year
• Expanding on Recursive Dates CTE
• Multiple CTEs in a Query
• Nested CTEs
• Nested CTE’s Gone Wild – The Video
• CTE Data Paging
• CTE Data Paging in a Procedure
• What Do You Use CTEs for?
• Using a CTE in a Function to Split Up a Query String
• Using a CTE to Split a String Into Rows
• Can we use CTEs use in SSRS?
• CTE Hierarchy compared to the alternative
• Calculating Factorials with a Recursive CTE
• CTE – With An Insert Statement
• Fibonacci Sequence
• Generating a Tree Path with a CTE
• CTE Query Performance
• Multiple CTE’s in a single Query
• Recursive CTE’s
• Common Table Expressions Page
• A Fun Thanksgiving Day Query.
• Common Table Expressions

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!