feroz_tt (4/16/2014)

---

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: