UFN_AUCTIONPACKAGE_CONVERT_UNROUNDED

Converts an amount from one currency to another without rounding using the given exchange rate ID.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@AMOUNT	money	IN
@CURRENCYEXCHANGERATEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_AUCTIONPACKAGE_CONVERT_UNROUNDED
            (
                @AMOUNT money,
                @CURRENCYEXCHANGERATEID uniqueidentifier = null
            )
            returns money
            as begin
                declare @ROUNDINGTYPECODE tinyint;
                declare @RATE decimal(20,8);

                if @CURRENCYEXCHANGERATEID is null
                    return 0;

                select
                    @ROUNDINGTYPECODE = CURRENCY.ROUNDINGTYPECODE,
                    @RATE = CURRENCYEXCHANGERATE.RATE
                from
                    dbo.CURRENCYEXCHANGERATE
                    inner join dbo.CURRENCY on CURRENCY.ID = CURRENCYEXCHANGERATE.TOCURRENCYID
                where
                    CURRENCYEXCHANGERATE.ID = @CURRENCYEXCHANGERATEID;

                return dbo.UFN_AUCTIONPACKAGE_APPLYRATE(@AMOUNT, @RATE);
            end