Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Common Table Expression (CTE) Rss

   Items 1 to 15 of 15   
 

CTE DML

Rating: (not yet rated) |  Discuss |   Briefcase | 1,803 reads

Using a Recursive CTE to Generate a List

Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.  Read more...
By Svetlana Marinova 2013/07/09 | Source: SQLServerCentral.com | Category: recursive cte
Rating: |  Discuss |   Briefcase | 10,681 reads

SQL Server 2005 Remove Dups - CTE

Easily remove duplicate records without temp tables by using a CTE.  Read more...
Rating: |  Discuss |   Briefcase | 6,854 reads

Data Profiling Column Functional Dependency T-SQL

This article demonstrates Data Profiling Functional Dependency  Read more...
By Ira Whiteside 2009/05/20 | Source: SQLServerCentral.com | Category: data profiling
Rating: |  Discuss |   Briefcase | 3,442 reads

Comparing Stored Procedures, Part 6

Sixth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures  Read more...
By Jesse McLain 2009/04/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,334 reads

Power and Deception of CTEs

A performance problem with a CTE based stored procedure, opened the developers eyes to a whole new world  Read more...
By Kev Riley 2008/12/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,885 reads

Uncommon Table Expressions

This article describes an alternate use of CTEs for functional data processing.  Read more...
By Peter Kierstead 2008/08/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,294 reads

Recursive Queries using Common Table Expressions (CTE) in SQL Server

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?  Read more...
By Additional Articles 2008/07/02 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,172 reads

Two Useful Hierarchy Functions

Two useful functions for dealing with hierarchical data.  Read more...
By John Cawley III 2008/05/21 | Source: SQLServerCentral.com | Category: hierarchies
Rating: |  Discuss |   Briefcase | 14,277 reads

SQL Server 2005 Remove Dups - CTE

Easily remove duplicate records without temp tables by using a CTE.  Read more...
Rating: |  Discuss |   Briefcase | 6,854 reads

CTEs in Report Creation

A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.  Read more...
Rating: |  Discuss |   Briefcase | 5,813 reads

Common Table Expressions

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.  Read more...
Rating: |  Discuss |   Briefcase | 13,348 reads

CTE Performance

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.   Read more...
By Peter He 2007/05/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,432 reads

CTEs and Trees

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.   Read more...
Rating: |  Discuss |   Briefcase | 5,436 reads

CTE Performance

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.   Read more...
By Peter He 2007/05/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,432 reads
   Items 1 to 15 of 15   
 
Tags
t-sql (9)    
advanced querying (1)    
data profiling (1)    
functional dependency (1)    
hierarchies (1)    
programming (1)    
readability (1)    
recursion (1)    
recursive cte (1)    
recursive function (1)    
report (1)