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)
Thank this author by sharing:
By Bhudev Prakash,
As several blogs/links are available for getting Time Dimension Scripts e.g.:
I required new Time Dimension script as I required little more information for Semister, Quater, Month,ForthNight, Week etc. Folloings are steps to create & populate data into Time Dimension table:
Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only on...
Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only on...
Incremental script for the time dimension
Dim_Date and Dim_Time. Date and Time dimensions. Creation, population with holidays, indexing and u...
generating or populating time dimensions in sql