UFN_BBNC_GETBATCHPROCESSORID_FROMEVENTTRANSACTIONID

      create function dbo.UFN_BBNC_GETBATCHPROCESSORID_FROMEVENTTRANSACTIONID(@TRANSACTIONID uniqueidentifier, @TRANSACTIONTYPE nvarchar(40))
      returns uniqueidentifier
      as begin
          return(
                    SELECT TOP 1 MAPPING.NETCOMMUNITYTRANSACTIONPROCESSORID AS PROCESSORID from NETCOMMUNITYBATCHPROCESSORSPLITMAPPING MAPPING
                        inner join NETCOMMUNITYTRANSACTIONPROCESSOR PROCESSOR on MAPPING.NETCOMMUNITYTRANSACTIONPROCESSORID = PROCESSOR.ID 
                        and PROCESSOR.TRANSACTIONTYPE = @TRANSACTIONTYPE
                        where MAPPING.NETCOMMUNITYPARENTTRANSACTIONPROCESSORID = @TRANSACTIONID
                )
      end