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:
- To Create DimTime Table execute Script 1
- By Default it will populate data between 01-01-2010 and 31-12-2020 dates. If anybody wants to change date range please set date values for parameters @StartDate & @EndDate.
- To Populate Data into DimTime table execute Script 2