There is a plethora of new T-SQL features and enhancements in SQL Server 2005. Learn about one of them — specifically, Common Table Expressions (CTE), because they often come in handy.
SQL Server 2005 Programmability Enhancements � Common Table Expressions
Published 05/16/2006
