SQLServerCentral.com Articles tagged Recursion

Unpack an Integer with SQL Server Recursion

Fri, 26 Apr 2013 06:00:00 UT

Starting with SQL Server 2005, developers have had recursion available as a T-SQL language feature. This article describes recursion and its SQL Server implementations, complete with examples. It also includes SQL Server functions and a stored procedure that unpacks, or parses, an integer into its multiple-of-two components.

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.

Using Recursion and Date Tables to Simplify Date Logic

Tue, 13 Dec 2011 07:00:00 UT

Learn to simplify date logic using date tables and recursion in T-SQL with this article from David Beardsley.

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.

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.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Merge error handling

Tue, 02 Nov 2010 06:00:00 UT

Learn to use recursion to determine which row caused your merge statement to fail in this article.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

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.

Concatenating Rows

Fri, 04 Mar 2011 07:00:00 UT

Recursion with SQL Server 2008 within the Financial World

Thu, 17 Sep 2009 06:00:00 UT

As most of you, we in the financial world have often been faced with the challenge of extracting data from relational sources that within the business frame of reference are more hierarchical in nature. Recently, I did what most of us do from time to.