Post reply

date table

  • October 25, 2010 at 3:04 pm

    #228419

    how do I create a date table that autogrows everyday with a new row(date) being inserted everyday.

  • October 25, 2010 at 3:09 pm

    #1241952

    Create the date table and then setup a SQL Server job to add new rows as needed.

    However, why don't you just setup a date table and add rows for many years to come, and maybe setup a job to insert a new years worth of data every year.

    You can use the function on the following link to load a date table for any time range you want.

    Date Table Function F_TABLE_DATE

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply