TR_COMMUNICATIONLETTERACTIVITYEXCLUSIONS_DELETE

CREATE trigger dbo.TR_COMMUNICATIONLETTERACTIVITYEXCLUSIONS_DELETE on dbo.COMMUNICATIONLETTERACTIVITYEXCLUSIONS after delete not for replication
as begin
  set nocount on;

  declare @CHANGEAGENTID uniqueidentifier;
  declare @IDSETREGISTERID uniqueidentifier;

  if (select count(ID) from DELETED) = 1
    begin
      select
        @IDSETREGISTERID = DELETED.IDSETREGISTERID,
        @CHANGEAGENTID = DELETED.CHANGEDBYID
      from DELETED;

      if @IDSETREGISTERID is not null
        exec dbo.[USP_IDSETREGISTER_DELETEBYID_WITHCHANGEAGENTID] @IDSETREGISTERID, @CHANGEAGENTID;

    end

  else
    begin
      declare DELETEDCURSOR cursor local fast_forward for
        select
          DELETED.IDSETREGISTERID,
          DELETED.CHANGEDBYID
        from DELETED;

      open DELETEDCURSOR;
      fetch next from DELETEDCURSOR into @IDSETREGISTERID, @CHANGEAGENTID;

      while (@@FETCH_STATUS = 0)
        begin
          if @IDSETREGISTERID is not null
            exec dbo.[USP_IDSETREGISTER_DELETEBYID_WITHCHANGEAGENTID] @IDSETREGISTERID, @CHANGEAGENTID;

          fetch next from DELETEDCURSOR into @IDSETREGISTERID, @CHANGEAGENTID;
        end

      close DELETEDCURSOR;
      deallocate DELETEDCURSOR;
    end
end