SQL Clone
SQLServerCentral is supported by Redgate
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,350 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,717 reads
   Items 1 to 2 of 2