TR_DELIVERYMETHOD_UPDATE_PRINTCODE (Trigger)

                
                    create trigger TR_DELIVERYMETHOD_UPDATE_PRINTCODE 
                    on dbo.DELIVERYMETHOD
                    after insert,update not for replication
                    as begin
                        set nocount on;
                        
                        if update(EMAILREQUIRED) or update(PRINTCODE)
                        begin
                            update dbo.DELIVERYMETHOD
                            set 
                                DELIVERYMETHOD.EMAILREQUIRED = 1,
                                DELIVERYMETHOD.CHANGEDBYID = inserted.CHANGEDBYID,
                                DELIVERYMETHOD.DATECHANGED = inserted.DATECHANGED
                            from dbo.DELIVERYMETHOD
                            inner join inserted on
                                DELIVERYMETHOD.ID = inserted.ID
                            where 
                                DELIVERYMETHOD.PRINTCODE = 2 and 
                                DELIVERYMETHOD.EMAILREQUIRED = 0
                        end
                        
                    end