Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Recursion Rss

   Items 1 to 19 of 19   
 

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 2014/07/25 (first published: 2012/07/17) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 19,987 reads

Sales Report on a View

Sales Report based on a single view  Read more...
By Sergiu Ungureanu 2013/09/17 | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 1,282 reads

Common table expressions and circular references

Finding circular references that are stopping your CTE from working.  Read more...
By Geoff Norman 2013/09/02 (first published: 2011/01/31) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 16,006 reads

Using a Recursive CTE to Generate a List

Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.  Read more...
By Svetlana Marinova 2013/07/09 | Source: SQLServerCentral.com | Category: recursive cte
Rating: |  Discuss |   Briefcase | 10,721 reads

Unpack an Integer with SQL Server Recursion

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.  Read more...
By Additional Articles 2013/04/26 | Source: Database Journal | Category: integers
Rating: (not yet rated)  Rate this |   Briefcase | 2,768 reads

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,369 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 2014/07/25 (first published: 2012/07/17) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 19,987 reads

Using Recursion and Date Tables to Simplify Date Logic

Learn to simplify date logic using date tables and recursion in T-SQL with this article from David Beardsley.  Read more...
By David Beardsley 2011/12/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,858 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 | 11,548 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: |  Discuss |   Briefcase | 147,307 reads

Common table expressions and circular references

Finding circular references that are stopping your CTE from working.  Read more...
By Geoff Norman 2013/09/02 (first published: 2011/01/31) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 16,006 reads

Merge error handling

Learn to use recursion to determine which row caused your merge statement to fail in this article.  Read more...
By Greg Nicol 2010/11/02 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 6,007 reads

Flexable Rate Recursion

A Recursion function that was used to apply a Rate percentage to a base amount for the reqested number of times.  Read more...
By Terry Steadman 2010/10/15 | Source: SQLServerCentral.com | Category: recursion
Rating: |  Discuss |   Briefcase | 533 reads

Print Tree

Stored proc which crawls a tree structure and dumps it in text and grid formats.  Read more...
By Peter Sloboda 2010/07/19 | Source: SQLServerCentral.com | Category: tree
Rating: |  Discuss |   Briefcase | 2,407 reads

Calculating Moving Averages with T-SQL

How to efficiently calculate moving averages with SQL Server using Stock Market data.  Read more...
By Gabriel Priester 2010/03/04 | Source: SQLServerCentral.com | Category: moving average
Rating: |  Discuss |   Briefcase | 14,966 reads

Riddle Me This

By Jason Brimhall 2009/12/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,891 reads

Print Tree

Stored proc which crawls a tree structure and dumps it in text and grid formats.  Read more...
By Peter Sloboda 2010/07/19 | Source: SQLServerCentral.com | Category: tree
Rating: |  Discuss |   Briefcase | 2,407 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: |  Discuss |   Briefcase | 147,307 reads

Recursion with SQL Server 2008 within the Financial World

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.  Read more...
By Stefaans 2009/09/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,646 reads
   Items 1 to 19 of 19   
 
Tags
t-sql (10)    
cte (8)    
annual (1)    
blogs (1)    
common table expressions (cte) (1)    
date manipulation (1)    
ema (1)    
holiday (1)    
humor (1)    
integers (1)    
macd (1)    
merge (1)    
moving average (1)    
pivot (1)    
rates (1)    
recursive cte (1)    
sma (1)    
string manipulation (1)    
tally table (1)    
tree (1)