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,927 reads
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
1,927 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,773 reads
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...
By Kevin3NF
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...
Comments posted to this topic are about the item Stairway to Database DevOps Level...
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Comments posted to this topic are about the item Creating Aggregates