>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only