Common Table Expressions are a great way to simplify complex derived table queries. If it makes sense to break out one derived table or subquery into a CTE, it can make sense to do multiple CTE’s. To use multiple CTE’s in a single query you just need to: Finish the first CTE Add a comma Declare the name and optional …
As part of my planning for the SQL Saturday Presentation in Vancouver I am creating an hour long presentation on Common Table Expressions. The easiest way to do a recursive query in SQL server is to use a recursive CTE (Common Table Expression). What is a Common Table Expression in SQL Server? Similar to the ease of a temporary table …
I just submitted a second abstract for SQL Saturday titled Unleashing Common Table Expressions in SQL Server. This is for the SQL Saturday Redmond and SQL Saturday Vancouver BC sessions. I am hoping to get three sessions accepted for Vancouver.