SQLServerCentral.com Content tagged T-SQL, Recursion

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.

Check SQL Server performance at a glance
We consulted 1000 SQL Server professionals to make SQL Monitor’s UI as clear as possible. Start monitoring with a free trial.

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.

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.

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.

Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

Riddle Me This

Mon, 21 Dec 2009 07:00:00 UT

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

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.