http://www.sqlservercentral.com/Content tagged CTE posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)A performance problem with a CTE based stored procedure, opened the developers eyes to a whole new worldhttp://www.sqlservercentral.com/articles/T-SQL/64797/2008/12/01http://www.sqlservercentral.com/articles/T-SQL/64797/This article describes an alternate use of CTEs for functional data processing.http://www.sqlservercentral.com/articles/T-SQL/63591/2008/08/11http://www.sqlservercentral.com/articles/T-SQL/63591/The problem arises when the hierarchy level increases as SQL Server is limited to 32 levels of recursion. We need a better way to implement recursive queries in SQL Server 2005. How do we do it?http://www.sqlservercentral.com/redirect/articles/63455/2008/07/02http://www.sqlservercentral.com/redirect/articles/63455/Two useful functions for dealing with hierarchical data.http://www.sqlservercentral.com/articles/Hierarchy/62858/2008/05/21http://www.sqlservercentral.com/articles/Hierarchy/62858/Easily remove duplicate records without temp tables by using a CTE.http://www.sqlservercentral.com/scripts/CTE/62599/2008/05/09http://www.sqlservercentral.com/scripts/CTE/62599/A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.http://www.sqlservercentral.com/articles/CTE/62404/2008/03/31http://www.sqlservercentral.com/articles/CTE/62404/They are new to SQL Server in 2005, but they are not necessarily in common use for many people. New author Kirk Kuykendall brings us a basic look on what a CTE is and how you can use it.http://www.sqlservercentral.com/articles/CTE/62291/2008/03/18http://www.sqlservercentral.com/articles/CTE/62291/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/