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

Scripts by Peter Diplaros

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Convert int to Excel column name

This script converts a numeric column index to an Excel column name (ex: AC)  Read more...
By Peter Diplaros 2013/11/07 | Source: SQLServerCentral.com | Category: excel
Rating: (not yet rated) |  Discuss |   Briefcase | 1,210 reads

Generate consecutive numbers

TSQL code that generates numbers (tally table) from 1 to N without using any tables  Read more...
By Peter Diplaros 2012/03/01 | Source: SQLServerCentral.com | Category: cross join
Rating: |  Discuss |   Briefcase | 1,679 reads
   Items 1 to 2 of 2