Tuesday, February 15, 2011

Date and Time dimension creation and population T-SQL

Just to point and give credit to this helpful script to create Date and Time dims in SSAS, I know that you can use the wizard in SSAS t ocreate and populate data in a date Dimension but not a time dimesion.

It's by Joshua A. Walker

The script is http://www.sqlservercentral.com/scripts/Data+Warehousing/65762/...