24 Hours of PASS – Advanced CTE Presenation

Today I am presenting on Advanced Common Table Expressions as part of the 24 Hours of PASS conference. It is being webcast so check it out if you can.

The outline for the presentation will be the following:

• Recursive Queries
• Hierarchical Recursive Data
• Manipulating Data
• Common Use Cases
• CTE Performance Considerations
• Classic Recursive Algorithms

The sample code and slides are available to download here:

AdvancedCTEs.zip

You can download the samples and follow along if you would like.

Enjoy!

Related Links:

• 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
• 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

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!