Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Sql Server database problm.

    got fixed. Permission problem.

  • RE: Select all months bewtween two dates

    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, ...

Viewing 2 posts - 1 through 2 (of 2 total)