Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Create and Populate a Date Dimension Table

By Joseph Morgan,

Add statements at the top to select your database



Save and run the script in the query analyzer. I have used this in SQL Server 2008, 2008R2 and 2012. I have no reason to believe it won't work in 2005 or even 2000, but I have not tested it in those environments.

Running on a Windows 7 Developer box against a 2008 R2 server it took about 43 sections to generate a 25-year table.

Total article views: 1399 | Views in the last 30 days: 4
data mart    
data warehouse    
date dimension