TR_BOARDMEMBERDATERANGE_MARKASCONSTITUENT

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