SQLServerCentral: Content tagged CTE

Generate N numbers

Reursive CTE Script to generate n numbers Read more...

By Harsha Majety 2013/04/17 | Source: SQLServerCentral.com | Category: recursion

Rating:

|

Discuss |

Briefcase | 1,022 reads

Multiple CTEs

Multiple CTEs It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can... Read more...

By Kenneth Fisher 2012/10/11 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 2,436 reads

Exploring Recursive CTEs by Example

Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons. Read more...

By Dwain Camps 2012/07/17 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 10,639 reads

Convert a string list to TABLE with single CTE query

Converts a string list into a table using a single query, no variables and no helper functions. Read more...

By Dimitris Staikos 2012/05/11 | Source: SQLServerCentral.com | Category: cte

Rating:

|

Discuss |

Briefcase | 1,927 reads

Pros and cons of six SQL table tools

This article shows how to use 6 SQL table-based tools to solve the same problem, and gives the pros and cons of each. Read more...

By Andy Owl 2011/12/26 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 8,558 reads

Dealing with Incomplete Data - A T-SQL Puzzle 1

Client data received for processing may have invalid records based on processing requirements. Identifying and dealing with bad records in a specific scenario is the object of this article. Read more...

By Suresh Maganti 2011/11/22 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 3,285 reads

Display multiple rows values as single row value (Different Columns)

Display multiple rows values as single row value in different rows (No Cursor). Read more...

By acuenca 2011/10/18 | Source: SQLServerCentral.com | Category: cte |

SQL Scripts Manager Compatible

Rating:

|

Discuss |

Briefcase | 2,763 reads

Calculating Stock Returns Using the ROW_NUMBER function and CTEs

In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue. Read more...

By John Ryle 2011/10/18 | Source: SQLServerCentral.com | Category: common table expressions

Rating:

|

Discuss |

Briefcase | 5,232 reads

Hidden RBAR: Counting with Recursive CTE's

"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code. Read more...

By Jeff Moden 2011/08/08 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 9,744 reads

Displaying Sorted Hierarchies (SQL Spackle)

Learn how you can query a hierarchy of data and also return the results in an ordered fashion. A handy T-SQL skill that you will use over and over again. Read more...

By Jeff Moden 2011/03/10 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 10,343 reads

Concatenating Rows

Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this. Read more...

By Carl P. Anderson 2011/03/04 (first published: 2009/10/14) | Source: SQLServerCentral.com | Category: t-sql

Rating: