Presented by Scott Heffron
Common table expressions (CTEs), a powerful and slick feature in SQL Server to make your SQL more readable and easier to maintain. They are similar to aliases (as in SELECT T1.* FROM MyTable T1) but much more useful. In essence, a CTE is a temporary result set that exists only within the scope of the statement in which it occurs.
Presentation and Example code into included in the zip file.