TR_STAFFDATERANGE_MARKASCONSTITUENT

                CREATE trigger TR_STAFFDATERANGE_MARKASCONSTITUENT 
                    on dbo.STAFFDATERANGE 
                    after insert, update
                    not for replication
                as begin
                    if update(CONSTITUENTID)
                    begin
                        update dbo.CONSTITUENT
                            set ISCONSTITUENT = 1,
                                CHANGEDBYID = inserted.CHANGEDBYID,
                                DATECHANGED = GetDate()
                        from inserted
                        where (CONSTITUENT.ID = inserted.CONSTITUENTID) and
                                (CONSTITUENT.ISCONSTITUENT = 0);
                    end
                end