Home Forums SQL Server 2005 T-SQL (SS2K5) ROUND() function doesn't round properly RE: ROUND() function doesn't round properly

  • October 2, 2009 at 4:33 am

    #1060836

    I think you are wrong in your assessment of round though,

    round(60.444445,1) = 60.4

    This

    PRINT ROUND(ROUND(ROUND(ROUND(ROUND(60.444445, 5), 4), 3), 2), 1)

    works because you are rounding a rounded , rounded, rounded , rounded number (ie the 5 has for want of a better word been cascaded up)


    Clear Sky SQL
    My Blog[/url]