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

Content with tag Recursive function Rss

   Items 1 to 3 of 3   
 

A simple math expression solver

Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.  Read more...
By Ben Kubicek 2011/11/21 | Source: SQLServerCentral.com | Category: recursive function
Rating: |  Discuss |   Briefcase | 5,435 reads

View - Table Usage (Recursive)

Written to explore the table dependencies of a view, especially when the view queries other views.  Read more...
By Rhett Clement 2009/01/22 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 1,001 reads

Recursive Queries using Common Table Expressions (CTE) in SQL Server

The problem arises when the hierarchy level increases as SQL Server is limited to 32 levels of recursion. We need a better way to implement recursive queries in SQL Server 2005. How do we do it?  Read more...
By Additional Articles 2008/07/02 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,199 reads
   Items 1 to 3 of 3   
 
Tags
t-sql (2)    
charindex (1)    
common table expressions (cte) (1)    
dependencies (1)    
information_schema (1)    
schema (1)