Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Adding a value to a 'date' column caused an overflow RE: Adding a value to a 'date' column caused an overflow

  • June 30, 2015 at 4:10 pm

    #1809334

    mandania (6/30/2015)

    I also think that rownum is high. No, salesdate is not devideby datetime. I should doing something like this

    rownumber <= datediff (day,salesdate,baseenddate) but i dont know how to implement it.

    case when RowNum <= datediff(day, salesdate, baseenddate)

    then DATEADD(mm, RowNum, salesdate)

    else 0 end

    Don Simpson


    I'm not sure about Heisenberg.