Home Forums SQL Server 2005 Backups Show data upto 2 decimal places but with exact values RE: Show data upto 2 decimal places but with exact values

  • drew.allen (11/1/2016)


    snowprincess42073 (10/31/2016)


    Hi all,

    I would like to show the data up to 2 decimal places but without rounding off the integers. If the number is 4.6758 then data retrieved should be 4.67 and not 4.68.

    I tried round, decimal, cast, etc. but each function converts the value to 4.68.

    Can anybody let me know the syntax so that I get the exact values after decimal.

    Best Regards,

    Htet Htet

    First, this thread is almost a decade old.

    Second, your post is an exact copy of the original post in this thread except for the name.

    Please do not resurrect old threads unless you have something valuable to contribute.

    Drew

    Lighten up, Drew. This isn't stackoverflow... 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)