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

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