>>>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
>>
>>?
>
>No, I did not try, there in this thread I read solution about mark records as deleted by set additional boolean field to true, and then
>update them instead delete. but then I can't use INSERT BULK for fast import.. or I have not enough exp. for this.

Here is a sample of MERGE operator you can use for your purpose

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/8d0dd918-e052-47fe-88de-00d6ebda85c2