I got query to get month order and year but not getting month names.

SELECT [year], [month]

FROM (

SELECT 2005 AS [year] UNION ALL

SELECT 2006 UNION ALL

SELECT 2007 UNION ALL

SELECT 2008 UNION ALL

SELECT 2009 UNION ALL

SELECT 2010 UNION All

SELECT 2011 UNION All

SELECT 2012 UNION ALL

SELECT 2013

) years

CROSS JOIN (

SELECT 1 AS [month] UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 5 UNION ALL

SELECT 6 UNION ALL

SELECT 7 UNION ALL

SELECT 8 UNION ALL

SELECT 9 UNION ALL

SELECT 10 UNION ALL

SELECT 11 UNION ALL

SELECT 12

) monthsorder

ORDER BY years.[year], monthsorder.[month]

can anybody help getting monthnames in same query??? so that i can create table