TR_COMMUNICATIONLETTERACTIVITYEXCLUSIONS_DELETE (Trigger)

                
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