Can anyone explain why the following SQL statement generates the answer 38.950000000000003
when it should be 38.96?
declare @inv_hours_Std as float
declare @inv_rate_Std as money
set @inv_hours_std = 5.25
set @inv_rate_std = 7.42
select round(@Inv_hours_std * @Inv_rate_std,2)
Can anyone help, this is an extract from code that generates invoices and half the lines are a penny out!!