Part 2 of new T-SQL enhancements from Srinivas Sampath. SQL Server 2005 contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Building on his first look at Common Table Expressions, Srinivas now looks at recursive queries with CTEs.
Author: Phillip Carter
Created on: Thursday, 3 March 2005
Full article available at http://www.sqlservercentral.com/columnists/sSampath/recursivequeriesinsqlserver2005.asp
By: Srinivas Sampath (http://www.sqlservercentral.com/columnists/sSampath)