Declare @date datetime ='2012-01-30' ;with cte as( select 1 Nos,@date MyDate union all select Nos+1,dateadd(mm,1,MyDate)MyDate from cte where Nos<12 ) select * from cte
Nos MyDate 1 2012-01-25 2 2012-02-25 3 2012-03-25 ...
Nos MyDate 1 2012-01-30 2 2012-02-29 3 2012-03-29 ...
Declare @date datetime set @date='2012-01-30'; with cte as( select 1 Nos,@date MyDate union all select Nos+1,dateadd(mm,Nos,@date)MyDate from cte where Nos<12 ) select * from cte
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)