HELP- Insert/Update Sloooow

Hi,

I have 2 tables, working table W and the history table H. W has 2 million rows. I need to compare a common column C in both tables. For a record in W, R, if R.C has a value that equals to a record's H.C in H, then update that record in H. Otherwise, R is considered a new record for H and will be inserted into H.

I used a cursor for loop for W. But the operation was extreamly slow. Any other solutions?

Thanks in advance.

MK Received on Wed Jan 05 2005 - 07:53:15 CST