Date and Time dimension creation and population T-SQL
Dim_Date and Dim_Time, Date and Time dimensions. Creation, population, indexing and use script.
Just copy the code into a query window and run the script.
There are no additional functions or procedures required.
This code will create the tables, populate the date and time tables, add holidays, add indexes and there are a few code snippets at the bottom for using them.Read more...