>Hi,
>I importing every day massive recordset from different manufacturers with updated pricelist and artikel set. Before import it, I delete old one, and then INSERT BULK another pricelist.
>Don't exact understand what you mean about pk_id, but pk_id field exist, its guid string and updatable
My question is - in that table do you have 1 record per manufacturer or many records per manufacturer?
Also, did you try MERGE statement (assuming you're using SQL 2008) to update records instead of deleting and insert non-matched delete not-matched by target
?
If it's not broken, fix it until it is.
My Blog