TR_EVENT_UPDATE_DELETELINKEDDESIGNATIONS (Trigger)

                
                    CREATE trigger TR_EVENT_UPDATE_DELETELINKEDDESIGNATIONS on dbo.EVENT after update not for replication
                    as begin
                        set nocount on;
                        
                        if update(DESIGNATIONSONFEES) and ((select count(*) from inserted where DESIGNATIONSONFEES = 0) > 0)
                            begin
                                delete from dbo.EVENTDESIGNATION
                                where EVENTDESIGNATION.EVENTID in (select ID from inserted)
                                                                
                                delete 
                                from dbo.REGISTRANTDESIGNATION
                                where REGISTRANTDESIGNATION.REGISTRANTID in (select REGISTRANT.ID from
                                dbo.REGISTRANT inner join inserted on REGISTRANT.EVENTID = inserted.ID)
                            end
                        
                    end