Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Get month names ordered using recursion

    You can use the ROW NUMBER of any large table as a list of integers. You can probably rely on the sysobjects table being there.

    select DATENAME(MONTH,DATEADD(MONTH,ROWNUM,0)- 1)[MonthName] from

    (select row_number()...

Viewing post 1 (of 1 total)