SQLServerCentral.com Content tagged T-SQL, CTE

Multiple CTEs

Thu, 11 Oct 2012 06:00:00 UT

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

Exploring Recursive CTEs by Example

Tue, 17 Jul 2012 06:00:00 UT

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

Pros and cons of six SQL table tools

Mon, 26 Dec 2011 07:00:00 UT

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

Dealing with Incomplete Data - A T-SQL Puzzle 1

Tue, 22 Nov 2011 07:00:00 UT

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.

Calculating Stock Returns Using the ROW_NUMBER function and CTEs

Tue, 18 Oct 2011 06:00:00 UT

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.

Hidden RBAR: Counting with Recursive CTE's

Mon, 08 Aug 2011 06:00:00 UT

"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.

Displaying Sorted Hierarchies (SQL Spackle)

Thu, 10 Mar 2011 07:00:00 UT

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.

Concatenating Rows

Fri, 04 Mar 2011 07:00:00 UT

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.

Common table expressions and circular references

Mon, 31 Jan 2011 07:00:00 UT

Finding circular references that are stopping your CTE from working.

Search all columns in every table for a value

Tue, 09 Nov 2010 07:00:00 UT

This script allows a user to search every field in a database for a specified value - handy when knowing the data but not the schema.

How to Compare Rows within Partitioned Sets to Find Overlapping Dates

Mon, 11 Oct 2010 06:00:00 UT

How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates

An Urgent Ad Hoc Report

Wed, 17 Mar 2010 06:00:00 UT

In this new article, Yakov Shlafman shows us how he wrote a quick ad hoc report of expenses so that he could leave on time one day.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Calculating Moving Averages with T-SQL

Thu, 04 Mar 2010 07:00:00 UT

How to efficiently calculate moving averages with SQL Server using Stock Market data.

How many rows are returned from the query below?

Wed, 03 Mar 2010 07:00:00 UT

Search all columns in every table for a value

Tue, 09 Nov 2010 07:00:00 UT

This script allows a user to search every field in a database for a specified value - handy when knowing the data but not the schema.

Riddle Me This

Mon, 21 Dec 2009 07:00:00 UT

Convert String to a Table using CTE

Mon, 14 Dec 2009 07:00:00 UT

Explains how to convert a list of Ids passed as string and convert it to a table

Concatenating Rows

Fri, 04 Mar 2011 07:00:00 UT

The Dynamic Tally or Numbers Table

Tue, 22 Sep 2009 06:00:00 UT

Building a tally table is a common T-SQL problem that many new developers struggle with. Lynn Pettis brings us an article that shows how to use CTEs to accomplish this.