UPDATE from SELECT using SQL Server - Stack Overflow
I'd modify Robin's excellent answer to the following: UPDATE Table SET Table.col1 = other_table.col1, Table.col2 = other_table.col2 FROM Table INNER JOIN other_table ON Table.id = other_table.id WHERE Table.col1 != other_table.col1 ......