By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create function dbo.AdjustAndRound(@currency varchar(max), @price decimal) returns decimal as
begin
if @currency = 'EUR'
return round(@price * 1.10, 2);
return floor(@price * 1.10);
end
select
*,
dbo.AdjustAndRound(Currency, Price) as Adjusted
from (
values ('EUR', 0.4), ('EUR', 1.2), ('EUR', 1.6), ('DKK', 59.2), ('DKK', 59.6)
) as Prices(Currency, Price)
| Currency | Price | Adjusted |
|---|---|---|
| EUR | 0.4 | 0 |
| EUR | 1.2 | 1 |
| EUR | 1.6 | 2 |
| DKK | 59.2 | 64 |
| DKK | 59.6 | 66 |