UFN_BBNC_EVENTREGISTRATION_GETBATCHSEPARATIONBYRULEID

            create function dbo.UFN_BBNC_EVENTREGISTRATION_GETBATCHSEPARATIONBYRULEID(@RULEID uniqueidentifier, @TRANSACTIONTYPE nvarchar(40))
            returns bit
            as begin
                return(
                    select IIF(((select count(1) from NETCOMMUNITYMAPPINGRULE MAPPINGRULE inner join NETCOMMUNITYBATCHPROCESSORSPLITMAPPING MAPPING 
                    on MAPPINGRULE.ID = MAPPING.NETCOMMUNITYMAPPINGRULEID and MAPPING.NETCOMMUNITYPARENTMAPPINGRULEID = @RULEID
                    inner join NETCOMMUNITYTRANSACTIONPROCESSOR PROCESSOR on MAPPING.NETCOMMUNITYTRANSACTIONPROCESSORID = PROCESSOR.ID 
                    and PROCESSOR.TRANSACTIONTYPE = @TRANSACTIONTYPE) > 0), 1, 0)
                )
            end