Viewing post 1 (of 1 total)
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()...
March 13, 2012 at 4:07 pm
#1458902