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.
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!