• 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