UFN_BBNC_TRANSACTIONPROCESSOR_GETFROMDOWNLOADEXCEPTIONID

      CREATE function dbo.UFN_BBNC_TRANSACTIONPROCESSOR_GETFROMDOWNLOADEXCEPTIONID
      (
       @ID uniqueidentifier
      )
      returns uniqueidentifier
      with execute as caller
      as 
      begin
        declare @PROCESSORID uniqueidentifier = null;

          select 
            @PROCESSORID = coalesce(tex.PROCESSORID,tp.ID)
        from 
            dbo.Transactions t inner join 
          dbo.BBNCTRANSACTIONDOWNLOADEXCEPTION tex on tex.BBNCTranID = t.ID left join
            dbo.NETCOMMUNITYTRANSACTIONPROCESSOR tp on t.TransactionType = tp.TRANSACTIONTYPE and tp.ISACTIVEPROCESSOR = 1
        where 
            tex.ID = @ID

        return @PROCESSORID;
      end