TR_TEAMFUNDRAISINGTEAMCAPTAIN_MARKASCONSTITUENT (Trigger)

                
                    create trigger TR_TEAMFUNDRAISINGTEAMCAPTAIN_MARKASCONSTITUENT
                        on [dbo].[TEAMFUNDRAISINGTEAMCAPTAIN]
                        after insert, update
                        not for replication
                    as begin
                        if update(CONSTITUENTID)
                        begin
                            update dbo.CONSTITUENT
                                set ISCONSTITUENT = 1,
                                    CHANGEDBYID = inserted.CHANGEDBYID,
                                    DATECHANGED = GetDate()
                            from dbo.CONSTITUENT
                                inner join inserted
                                    on inserted.CONSTITUENTID = CONSTITUENT.ID
                            where (CONSTITUENT.ISCONSTITUENT = 0)
                        end
                    end