In a stored procedure I need to create a temporary table that has one column (date). Then I need to insert every day for the past... let's say year. So I need an entry for every day from 1/1/2002 to the current day.
I know how to create the table but am having trouble getting the data into the table. Anyone have any ideas on how to do this?
thanks
I know how to create the table but am having trouble getting the data into the table. Anyone have any ideas on how to do this?
thanks