TR_GROUPDATA_MARKNONHOUSEHOLDASCONSTITUENT (Trigger)

                
CREATE trigger dbo.TR_GROUPDATA_MARKNONHOUSEHOLDASCONSTITUENT
    on dbo.GROUPDATA
    after insert, update
    not for replication
as begin
    if (update(GROUPTYPECODE))
    begin
        update dbo.CONSTITUENT
        set CONSTITUENT.ISCONSTITUENT = 1,
            CONSTITUENT.CHANGEDBYID = inserted.CHANGEDBYID,
            CONSTITUENT.DATECHANGED = GetDate()
        from dbo.CONSTITUENT
            inner join inserted
                on CONSTITUENT.ID = inserted.ID
        where GROUPTYPECODE != 0;
    end
end