USP_DATALIST_GETCURRENCYEXCHANGERATE

Gets the latest daily/corporate exchange rate from one currency to another

Parameters

Parameter	Parameter Type	Mode	Description
@FROMCURRENCYID	uniqueidentifier	IN	From currency ID
@TOCURRENCYID	uniqueidentifier	IN	To currency ID

Definition

Copy



      CREATE procedure dbo.USP_DATALIST_GETCURRENCYEXCHANGERATE
      (
          @FROMCURRENCYID uniqueidentifier,
          @TOCURRENCYID uniqueidentifier
      )
      as
          set nocount on;

          declare @EXCHANGERATEID uniqueidentifier
          select @EXCHANGERATEID = dbo.UFN_CURRENCYEXCHANGERATE_GETLATEST (@FROMCURRENCYID, @TOCURRENCYID, null, 1, null) 

          if @EXCHANGERATEID is not null
              select dbo.UFN_CURRENCYEXCHANGERATE_GETRATE(@EXCHANGERATEID)