UFN_EVENTREGISTRANT_GETBALANCEINCURRENCY

            CREATE function dbo.UFN_EVENTREGISTRANT_GETBALANCEINCURRENCY
            (
                @REGISTRANTID uniqueidentifier,
        @CURRENCYID uniqueidentifier
            )
            returns money
            as
            begin

        declare @AMOUNT money;
        declare @EVENTCURRENCYID uniqueidentifier;

        set @AMOUNT = dbo.UFN_EVENTREGISTRANT_GETBALANCE(@REGISTRANTID);

        select @EVENTCURRENCYID = EVENT.BASECURRENCYID
        from dbo.REGISTRANT
        inner join dbo.EVENT on EVENT.ID = REGISTRANT.EVENTID
        where REGISTRANT.ID = @REGISTRANTID;

        if @CURRENCYID = @EVENTCURRENCYID
          return @AMOUNT
        else
        begin
          declare @CURRENCYEXCHANGERATEID uniqueidentifier = dbo.UFN_CURRENCYEXCHANGERATE_GETLATESTINCLUDEEXPIRED(@EVENTCURRENCYID, @CURRENCYID, GETDATE(), 1, null);
          set @AMOUNT = dbo.UFN_CURRENCY_CONVERT(@AMOUNT, @CURRENCYEXCHANGERATEID);
        end
        return @AMOUNT
      end