I can't see why that would fail when you insert the output into a table that has decimal(5,2) for that column's data type.

Try doing a SELECT INTO... and seeing if that works (and what the created column data type is).