Post reply

Know Your Data

  • March 24, 2005 at 3:11 pm

    #362249

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rcarlson/knowyourdata.asp

  • April 4, 2005 at 10:34 am

    #550373

    Totally agree. Just had a similar task. I used multiplying by 1.00 and then used Convert to make the output look nice for the report

    Convert(decimal(7,3),Orders*1.00/mytotal)

    Yelena

    Regards,Yelena Varsha

  • April 18, 2005 at 5:47 am

    #553112

    Article provides good insight. I found this issue while I was trying to write a big stored procedure to run complex calcualtions.

    I did not know the adding or subtracting .0 technique .

    I created temporary variables of decimal type and reassigned values to these variables and used them in my calculation. But adding .0 would have been far more simpler and efficient.

    Raja

     

     

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

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