Similarly if you want to list all the month names for a year using a T-SQL statement, you can do this:

SELECT Number + 1 as [MonthNumber],

DateName(mm,DATEADD(mm,Number,0)) as [MonthName]

FROM master..spt_values

WHERE Type...

That query gives perfect result.

Thanks.

Mandar Kavishwar.

EC Infosolution