SQLServerCentral.com Articles tagged CTE

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.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

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.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

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.

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.

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.

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.