The rounding problem occurs after many operations, usually not in just few operations.

Try adding $0.01 to a total for 1000 times

DECLARE @Total FLOAT

DECLARE @i INT

SET @Total = 0

SET @i =...