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)
2,019 reads
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
2,019 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,783 reads
The other day I came across an interesting repo on github, KubeDiagrams. What this...
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
SQL Server migrations are a headache, ask anyone who’s been through the pain of...
Please I am struggling to understand the difference between these two queries. It behaves...
Comments posted to this topic are about the item Introduction to PostgreSQL for the...
Hi we know (or believe) ssas saas gets stood up separately when a company...
I have this code:
SELECT CHOOSE (MONTH (saledate), 'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Autumn') AS x FROM ProductSales;What is a good name for the column alias? See possible answers