Post reply

Stop SQL2K Rounding

  • May 13, 2005 at 2:53 pm

    #93001

    Does anyone know how to stop SQL2K from rounding [smallmoney] columns when CAST and returned in an sp? For example, "select boy + CAST(age as varchar(7)) + ' is years old' from mychild" It will return 3.38 instead of 3.3750.

    However, if you just "select age from mychild" it displays 3.3750. Does anyone have any clues? 

     

  • May 15, 2005 at 10:40 am

    #558932

    Try this, instead...

    "select boy + REPLACE(STR(age,7,4),' ','') + ' is years old'

    --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)

  • May 16, 2005 at 6:48 am

    #558995

    Thanks Old Hand. That works perfectly!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply