USP_NETCOMMUNITYCHILDPROCESSOR_DELETEBYID_WITHCHANGEAGENTID

    CREATE procedure dbo.USP_NETCOMMUNITYCHILDPROCESSOR_DELETEBYID_WITHCHANGEAGENTID
    (
        @ID uniqueidentifier,
        @CHANGEAGENTID uniqueidentifier
    )
    as
    begin
      create table CHILDPROCESSORIDS
      (
        ID int IDENTITY(1,1) PRIMARY KEY,
        CHILDPROCESSORID uniqueidentifier not null
      )

      insert into CHILDPROCESSORIDS(CHILDPROCESSORID)
        (select NETCOMMUNITYTRANSACTIONPROCESSORID from NETCOMMUNITYBATCHPROCESSORSPLITMAPPING 
        where NETCOMMUNITYPARENTTRANSACTIONPROCESSORID = @ID)

      declare @MAXCOUNT int, @COUNT int = 1, @PID uniqueidentifier

      select @MAXCOUNT = count(1) from CHILDPROCESSORIDS
        set @COUNT = 1

        while @COUNT <= @MAXCOUNT
          begin
                select @PID =  CHILDPROCESSORID from CHILDPROCESSORIDS where ID = @COUNT

            --Delete PUB/ERB child processor of event processor

                exec dbo.USP_NETCOMMUNITYTRANSACTIONPROCESSOR_DELETEBYID_WITHCHANGEAGENTID  @PID, @CHANGEAGENTID;
                set @COUNT = @COUNT + 1
          end
          drop table CHILDPROCESSORIDS
    end