how to select last 12 months name and year without using tables using sql query?
SET LANGUAGE English;WITH R(N) AS(SELECT 0UNION ALLSELECT N+1 FROM RWHERE N < 12)SELECT LEFT(DATENAME(MONTH,DATEADD(MONTH,-N,GETDATE())),3) AS [month], DATEPART(YEAR,DATEADD(MONTH,-N,GETDATE())) AS [year]FROM R
declare @start DATE = '2011-10-01'; with CTEE(date)AS( SELECT @start UNION all SELECT DATEADD(month,-1,date) from CTEE where DATEADD(month,-1,date)>=DATEADD(month,-10,@start))select Datename(month,date) from CTEE
SELECT STR(MONTH(DATEADD(mm, number, GETDATE())), 2) AS MonthNum, DATENAME(month, DATEADD(month, MONTH(DATEADD(mm, number, GETDATE())), 0) - 1) AS MonthNamesFROM master.dbo.spt_valuesWHERE (name IS NULL) AND (number BETWEEN 0 AND 11)