DECLARE @year VARCHAR(10)

SELECT @year='2009'

SELECT

LEFT(CONVERT(VARCHAR,DATEADD(MM,number,@year),112),4)+' '+LEFT(DATENAME(MM,DATEADD(MM,number,@year)),3)

FROM

Master..spt_Values

WHERE

Type='p' AND

number < DATEPART(MM,GETDATE())-1