Home Forums SQL Server 2005 T-SQL (SS2K5) Round real Value withoot truncation RE: Round real Value withoot truncation

  • July 3, 2009 at 12:20 am

    #1019618

    print cast( ROUND(@real + CAST(0.5E * POWER(0.1E, 2) AS DECIMAL(15, 3)), 2, 1) AS decimal(15, 2))

    N 56°04'39.16"
    E 12°55'05.25"