Get Month and Year

DECLARE @date DATETIME;
SET @date = '2006-10-15';
SELECT DATENAME(MONTH,DATEADD(mm,-12,@date)),DATENAME(YEAR,DATEADD(mm,-12,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DateAdd(mm,-11,@date)),DATENAME(YEAR,DATEADD(mm,-11,@date))
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-10,@date)),DATENAME(YEAR,DATEADD(mm,-10,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-09,@date)),DATENAME(YEAR,DATEADD(mm,-09,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-08,@date)),DATENAME(YEAR,DATEADD(mm,-08,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-07,@date)),DATENAME(YEAR,DATEADD(mm,-07,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-06,@date)),DATENAME(YEAR,DATEADD(mm,-06,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-05,@date)),DATENAME(YEAR,DATEADD(mm,-05,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-04,@date)),DATENAME(YEAR,DATEADD(mm,-04,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-03,@date)),DATENAME(YEAR,DATEADD(mm,-03,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-02,@date)),DATENAME(YEAR,DATEADD(mm,-02,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-01,@date)),DATENAME(YEAR,DATEADD(mm,-01,@date))