SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag Recursive CTE Rss

Search for any content tagged recursive cte

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 3 of 3   

Work time calculation

One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time  Read more...
By Alessandro Mortola 2016/09/29 | Source: SQLServerCentral.com | Category: datefirst
Rating: |  Discuss |   Briefcase | 467 reads

Recursive CTE Example

Use a recursive CTE to select hirearchial data in a single SQL statement.  Read more...
By Neil Bryan 2013/09/26 | Source: SQLServerCentral.com | Category: recursive cte
Rating: |  Discuss |   Briefcase | 2,666 reads

Identify Bad Characters in a Table Column

An interesting recursive CTE to list out the non-alphanumeric characters in a column of a table.  Read more...
Rating: |  Discuss |   Briefcase | 2,494 reads
   Items 1 to 3 of 3