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

  • July 2, 2009 at 4:50 am

    #1019028

    DECLARE@n TINYINT

    SET@n = 2

    DECLARE@Sample TABLE

    (

    Value DECIMAL(15, 7)

    )

    INSERT@Sample

    SELECT18.0049 UNION ALL

    SELECT18.005

    SELECTValue,

    ROUND(Value + CAST(0.5E * POWER(0.1E, @n) AS DECIMAL(15, 7)), @n, 1)

    FROM@Sample

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