http://www.sqlservercentral.com/Content tagged T-SQL, CTE posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)SQL Server 2005 brings a new feature to T-SQL with Common Table Expressions, which make it possible for more complex subquery expressions than in previous versions. Recursion is a common use and Peter He takes a look at how well these new structures perform. http://www.sqlservercentral.com/articles/T-SQL/2926/2008/03/14http://www.sqlservercentral.com/articles/T-SQL/2926/Some new interresting points about trees and CTE in SQL Server : transforming a tree from auto reference to interval model (nested sets), calculating levels in interval model, creating a view of auto ref from an interval model, hierarchical numbering of items, and more. This article includes more examples based on his previous work. http://www.sqlservercentral.com/articles/CTE/61510/2007/12/26http://www.sqlservercentral.com/articles/CTE/61510/SQL Server 2005 brings a new feature to T-SQL with Common Table Expressions, which make it possible for more complex subquery expressions than in previous versions. Recursion is a common use and Peter He takes a look at how well these new structures perform. http://www.sqlservercentral.com/articles/T-SQL/2926/2008/03/14http://www.sqlservercentral.com/articles/T-SQL/2926/