SDU Tools: Calculate Date Dimension Columns in T-SQL

added by DotNetKicks
2/28/2019 2:06:17 PM

1 Kicks, 398 Views

Calculating the columns required for a date dimension using T-SQL is a pretty common request from SQL Server developers. So we decided to make it really easy to do. In our free SDU Tools for developers and DBAs, there is a table-valued function called DateDimensionColumns, for just this purpose.