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
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.