Update rows in

I have two tables, Update1 and Master1. Master1 is thousands of records and is recreated twice a day. The Update1 rows are created when someone reads and updates a Master1 row (since Master1 gets dropped and recreated twice a day).

I am writing a stored proc to re-connect the two tables. My question is: what is the most performant way when I drop and repopulate Master1, to iterate through Update1 and to set a bit column to true in Master1 (if a record exists in Update1)?

Any help would be appreciated.

re: Update rows in

Try something like this

re: Update rows in

gpl,

Thanks for the pointer. I was trying to avoid a join, but if that will likely be faster than using a cursor (I would think).