Who can help
My triggers do not fire when doing a batch insert with a store procedure
we have a:
Insert Into <Table> (column,column,..n)
select column,column,..n from <tableName> where x = z
This would place some 5 rows in the table.
a trigger makes the PK field based on a calculation
the trigger works well when there is a single row update. with this batch
however we get the "Duplicate PKey " error.