Hi All,
I'm getting some problem here
;with Numbers (Number) as
(select row_number() over (order by object_id)
from sys.all_objects)
select dateadd(month, number, '2014-09-01')
from Numbers
where number <= datediff(month, '2014-09-01', '2016-03-31')
Low no of months.
Select datediff(month, '2014-09-01', '2016-03-31')
it should give 31 instead of 18.
I don't understand where i'm wrong:unsure: