USP_CURRENCYEXCHANGERATE_GETRATEFORCONVERT

Loads information necessary for converting an amount in one currency to another.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@RATE	decimal(20, 8)	INOUT
@TOCURRENCYDECIMALDIGITS	tinyint	INOUT
@TOCURRENCYROUNDINGTYPECODE	tinyint	INOUT

Definition

Copy



create procedure dbo.USP_CURRENCYEXCHANGERATE_GETRATEFORCONVERT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @RATE decimal(20,8) = null output,
    @TOCURRENCYDECIMALDIGITS tinyint = null output,
    @TOCURRENCYROUNDINGTYPECODE tinyint = null output
)
as
begin
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @RATE = CURRENCYEXCHANGERATE.RATE,
        @TOCURRENCYDECIMALDIGITS = [TOCURRENCY].DECIMALDIGITS,
        @TOCURRENCYROUNDINGTYPECODE = [TOCURRENCY].ROUNDINGTYPECODE
    from
        dbo.CURRENCYEXCHANGERATE
        left join dbo.CURRENCY as [TOCURRENCY] on [TOCURRENCY].ID = CURRENCYEXCHANGERATE.TOCURRENCYID
    where
        CURRENCYEXCHANGERATE.ID = @ID;

    return 0;

end