Know Your Data

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

  • 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

  • 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