Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Modulus Rss

   Items 1 to 3 of 3   
 

Convert Rows into Columns

Convert the rows of a SELECT statement into a predetermined number of columns.  Read more...
By M Patrick Dillon 2015/12/11 (first published: 2014/07/17) | Source: SQLServerCentral.com | Category: rows to columns
Rating: |  Discuss |   Briefcase | 26,313 reads

Convert Rows into Columns

Convert the rows of a SELECT statement into a predetermined number of columns.  Read more...
By M Patrick Dillon 2015/12/11 (first published: 2014/07/17) | Source: SQLServerCentral.com | Category: rows to columns
Rating: |  Discuss |   Briefcase | 26,313 reads

Need the First Tuesday Beyond Y days after X Date

A task was set before our team to find the first Tuesday after 10 days from a specific date. This article shows how we accomplished that.  Read more...
By Charles Martin 2011/10/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,517 reads
   Items 1 to 3 of 3   
 
Tags
date (1)    
date manipulation (1)    
over (1)    
row_number (1)    
rows to columns (1)