Common Table Expressions (CTE) – Underappreciated Features of Microsof

This is part of the series of posts that I am running under the title " Under Appreciated Features of SQL Server ". The series has been inspired by Andy Warren's editorial on SQLServerCentral.com. Did you ever wonder if you could create a temporary result set and use that within a single...