>>>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.
What is your SQL Server version? If it's 2008, then I suggest to re-think your approch - instead of delete old - insert new try to update old insert new.
The only caveat here it's not as easy to implement batches for the MERGE operator as for single operation.
I suggest to also ask your question in this forum
http://social.msdn.microsoft.com/Forums/en-US/transactsql/threadsYou have much more T-SQL experts there than here.
If it's not broken, fix it until it is.
My Blog