• Lets play a bit:

    Select cast(100 as real) * 1.05,cast(cast(100 as real) * 1.05 as int);

    -- Result is 105, 104

    The result is very strange for me. Does SQL Server the calculation from inside to outside or not? :w00t: