Creating and populating Date dimension in a DW for use in SSAS

Here is a script I found on SQLDusty’s blog on how to populate a Date dimension.

I am re-posting this script here so I can have access to it at any time. Props to Dustin!

 

?View Code TSQL–Make sure you set the Start and End Date below on row 58 and 59
–Create the tables
BEGIN TRY

Continue reading […] Creating and populating Date dimension in a DW for use in SSAS […]