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,859 reads
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
1,859 reads
TSQL code that generates numbers (tally table) from 1 to N without using any tables
2012-03-01 (first published: 2012-02-21)
1,768 reads
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
I have a production server with SQL server 2016 version (13.0.5026.0) and a database...
I am trying to use unpivot to extract some data, however, the results are...
hi, I have one nested transaction and want to deescalate to outer transaction's isolation/...