I have the need to update a bunch of values in a table and the column data type is "Money", the value should be increased with 5% and make the correct rounding. I tried this, but thats not right...
DECLARE @Price money
SET @Price = 1.19
SELECT @Price * 1.04
PRINT CONVERT(DECIMAL(7,2), @Price)
Can anyone help?