Report Portal

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...

Tags: time dimension, script

 

2007-2015 VidasSoft Systems Inc.