UFN_CURRENCYEXCHANGERATE_GETRATE
Returns the exchange rate of the given exchange rate ID.
Return
| Return Type |
|---|
| decimal(20, 8) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENCYEXCHANGERATEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_CURRENCYEXCHANGERATE_GETRATE
(
@CURRENCYEXCHANGERATEID uniqueidentifier
)
returns decimal(20,8)
as
begin
return (
select
CURRENCYEXCHANGERATE.RATE
from
dbo.CURRENCYEXCHANGERATE
where
CURRENCYEXCHANGERATE.ID = @CURRENCYEXCHANGERATEID
)
end