TR_GROUPDATA_T2BINSERT

create trigger dbo.TR_GROUPDATA_T2BINSERT on dbo.GROUPDATA after insert not for replication as
begin
  delete from dbo.TA_NEWCONSTITUENT
  where ID in(select ID from INSERTED where GROUPTYPECODE = 1);
end