Convert int to Excel column name
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
1,429 reads
Peter Diplaros
Generate consecutive numbers
TSQL code that generates numbers (tally table) from 1 to N without using any tables
2012-03-01 (first published: 2012-02-21)
1,723 reads
Blogs
More Azure Blob Storage enhancements
By James-Serra
I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob...
Daily Coping 25 May 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
A Byte of Redgate–Bonus Queso Recipe
By Steve Jones
As part of the Community Circle effort at Redgate, we’ve released a cookbook: A...
Forums
HTML Mail with more than one line in Resultset
Hello all, i would like to send a html Mail with sql server. But...
AS Tabular and Sample Data in VS
Hello all, I really need your help – I want to use the sample...
SSIS Export Flat File as Fixed Width
Hi Forum, I have a table that uses the script below to create fields...
Ask SSC