DECLARE @dt DATETIME = '20120111';

;WITH N(n) AS
(SELECT 1 UNION ALL SELECT n+1 FROM N WHERE n < 36)
SELECT 
	DATEADD(mm,DATEDIFF(mm,0,@dt)-n,0)
FROM
	N;

quote:

---

Originally posted by sunitabeck

Something like this?

DECLARE @dt DATETIME = '20120111';

;WITH N(n) AS
(SELECT 1 UNION ALL SELECT n+1 FROM N WHERE n < 36)
SELECT 
	DATEADD(mm,DATEDIFF(mm,0,@dt)-n,0)
FROM
	N;

---

quote:

---

Originally posted by daliri

I want to show all month of 3 different years in sql , how can H do it?

---