• what about this:

    update table1

    set table1.column1 = #table.column1, table1.column2 = #table.column2

    from table1, #table

    where table1.pk=#table.pk