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 2, 2010 at 1:52 am

    #1112123

    Paul, nice solution! However, the first day of the month is missing. Either subtract 1 from DayOffset.n as the parameter for the dateadd function or use a zero-based DayOffset (0-30) will fix it.

    Peter