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 [url]http://www.sqlservercentral.com/columnists/sSampath/recursivequeriesinsqlserver2005.asp[/url]
By: Srinivas Sampath ([url]http://www.sqlservercentral.com/columnists/sSampath[/url])