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