Using Common Table Expressions in SQL Server 2005

Using common table expressions in SQL Server 2005 queries  From TecgRepublic.com. Common table expressions (CTEs), a powerful new feature in SQL Server 2005, make your SQL more readable and easier to maintain. See how you can use a CTE more than once in a SQL Server statement.