TR_CLIENTUSERMAILFORWARDING_DELETE (Trigger)

        create trigger dbo.TR_CLIENTUSERMAILFORWARDING_DELETE on dbo.ClientUserMailForwarding 
        after delete 
        not for replication
        as begin
        
            set nocount on;
          declare @CLIENTUSERID int;    
      
            if (select count(ID) from DELETED) = 1
            begin
              select
                @CLIENTUSERID = DELETED.CLIENTUSERSID
              from 
                DELETED;
                
               if @CLIENTUSERID is not null
               begin
                    declare @NETCOMMUNITYCLIENTUSERID uniqueidentifier;
            
                    select
                        @NETCOMMUNITYCLIENTUSERID = NETCOMMUNITYCLIENTUSER.ID
                    from
                        dbo.NETCOMMUNITYCLIENTUSER
                    where
                        BBNCUSERID = @CLIENTUSERID;
        
                    if @NETCOMMUNITYCLIENTUSERID is not null
                    --Delete the email forwarding address integration record associated with the netcommunity user
                    delete dbo.NETCOMMUNITYEMAILINFO where NETCOMMUNITYCLIENTUSERID = @NETCOMMUNITYCLIENTUSERID;
               end
            end
        end