What is a Common Table Expression – Video

Related Common Table Expression Links

• 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?
• End of June CTE Summary

• 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

You can also find more CTE examples on the TSQL Wiki.

If you enjoyed these Common Table Expression posting, and want to learn more about Common Table Expressions, please take a look at my book on CTE’s at Amazon.com. The book is titled Common Table Expressions – Joes 2 Pros® – A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs.

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!