Unos artikala/first setup
update tHE_SetItem set acSetOfItem = '13X' where acSetOfItem like '';
create trigger _PrenosItemSubj on tHE_SetItem
after insert, update
as
insert into tHE_SetItemExtItemSubj (acIdent, acSubject, acType, acCode, acName)
select g.acIdent, '', 'P', g.acCode, ''
from tHE_SetItem g
inner join inserted i on g.acIdent = i.acIdent
left join tHE_SetItemExtItemSubj t on g.acIdent = t.acIdent and g.acCode = t.acCode
where t.acIdent is null and t.acCode is null and g.acCode not like ''