June was an exciting month for me with Beta 6 of the Database Health Reports releasing at the beginning of the month, and this being CTE Month at SteveStedman.com to mark the release of my Common Table Expressions book.
CTE Month Summary
CTE Month postings started with the basics on June 1st, and grew throughout the month to include more advanced CTE content.
- June 1 – Common Table Expression (CTE) Month at SteveStedman.com (introduction)
- June 1 – Sample Database for Common Table Expressions
- June 2 – Writing Your First Common Table Expression with SQL Server
- June 3 – Video: Writing Your First CTE with SQL Server
- June 4 – Common Table Expressions – Terminating the Previous Statement
- June 5 – CTE Scope
- June 7 – Introduction to Recursive CTEs
- June 8 – Recursive CTE for Dates In A Year
- June 9 – Expanding on Recursive Dates CTE
- June 10 – Multiple CTEs in a Query
- June 11 – Nested CTEs
- June 12 – Nested CTE’s Gone Wild – The Video
- June 14 – CTE Data Paging
- June 15 –CTE Data Paging in a Procedure
- June 17 – What Do You Use CTEs for?
- June 30 – End of June CTE Summary
Since June is CTE month, here are some links to other CTE articles on my blog:
- 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.