I'm using SQL Server 2000 on a XP Pro machine.
I'm working on a DW project and need to populate a time dimension table in the data warehouse. This data is not in the OLTP and I would like to know if anyone knows of a script that will populate the columns in this table like, month, day of week, week, year. I can make the table, that is not a problem. The issue is getting the data and populating the table. Make sense?
I would rather not have to type all this information into the table.
Thank you for your help.