Here is a script to create a Dim Date and Dim Time table in a data warehouse. I did not write this script but it is a popular request and seems to be hard for people to find on other sites. So I thought I would post it here to make it easier for people to download.
You will need to alter the start date and end date to your desired time period.
I have improved the script and added fiscal dates also. I published this on a new blog here.
This is a great script, very thorough. Way better than mine. Thanks.
Thanks for sharing! It's interesting the logic applied for the US holidays... I little more tweaking, and I am sure other holidays for other countries can be added easily.