I have read lots of post about how to update multiple columns but still can't find right answer.
I have one table and I would like update this table from another table.
SELECT ..... with join ... where ....
TSQL does not support row-value constructor. Use this instead:
UPDATE table1 SET a = t2.a, b = t2.b, (...) FROM ( SELECT ..... with join ... WHERE .... ) t2 WHERE table1.id = table2.id