TR_STUDENTRELATIONCONSTITUENCYSETTINGS_INSERTUPDATE_MARKCONSTITUENTS (Trigger)

                
                    create trigger TR_STUDENTRELATIONCONSTITUENCYSETTINGS_INSERTUPDATE_MARKCONSTITUENTS
                        on dbo.STUDENTRELATIONCONSTITUENCYSETTINGS
                        after insert, update
                        not for replication
                    as begin
                        if update(RELATEDTOCODE)
                        begin
                        
                            update dbo.CONSTITUENT
                            set ISCONSTITUENT = 1,
                                CHANGEDBYID = INSERTED.CHANGEDBYID,
                                DATECHANGED = GetDate()
                            from                                 
                                dbo.UFN_CONSTITUENT_STUDENTRELATIONCONSTITUENCIES() as RELATIONCONSTITUENCIES
                            inner join 
                                INSERTED on RELATIONCONSTITUENCIES.STUDENTRELATIONCONSTITUENCYSETTINGSID = INSERTED.ID
                            where 
                                RELATIONCONSTITUENCIES.CONSTITUENTID = CONSTITUENT.ID
                                and CONSTITUENT.ISCONSTITUENT = 0
                            
                        end
                    end