Home Forums SQL Server 2008 T-SQL (SS2K8) T-SQL return record for every day of year RE: T-SQL return record for every day of year

  • February 1, 2010 at 2:45 pm

    #1111963

    hughesj23 (2/1/2010)

    I could join my table by month/year to another static table that just had all the days of the year in it. But I was hoping to avoid creating and remembering to maintain such a table every year.

    Thanks.

    Joel

    Create a scheduled job to run at the end of each month or year to add the values for the upcoming month or year.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]