quote:
Something like this (Check it out in BOL):update <master_Table>
set col1 = <temporary_table>.col1, col2 = <temporary_table>.col2 ....
from <master_table>, <temporary_table>
where <master_table>.<primary_key> = <temporary_table>.<primary_key>
I don't think you acutally need the exists statement as the join has the same effect - i.e. selects existing rows.
Cheers
David