TR_GROUPDATA_INSERT_HOUSEHOLD_UPDATE (Trigger)

                
CREATE trigger dbo.[TR_GROUPDATA_INSERT_HOUSEHOLD_UPDATE] on dbo.[GROUPDATA] after insert not for replication
as
begin
  set nocount on;

  --Insert new households into the constituent current household table...

  insert into dbo.[CONSTITUENTHOUSEHOLD] ([ID], [ISHOUSEHOLD])
    select
      [ID],
      1
    from inserted
    where [GROUPTYPECODE] = 0
    and not exists(select 1 from dbo.[CONSTITUENTHOUSEHOLD] where [ID] = inserted.[ID]);
end