Know Your Data

  • Comments posted to this topic are about the content posted at

  • 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



    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.




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

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