I am sorry, but I realy, realy don't understand why D is not good, even if I do your formula.

Why is so that D would have a truncate answer and not C?

I mean, both have a precision of 51 and only the scale is different (3 more digit more for C), which might explain something if you could explain my question here:

If I declare D as precision of 23 instead of 25 and still having a scale of 10

DECLARE @value1D DECIMAL(23,10), @value2D DECIMAL(23,10)

it is still a precision over 38, and the scale is still 20 as previous, but the answer is not truncate

Why??? :crazy: