Home Forums SQL Server 2014 Development - SQL Server 2014 Please let me know what is wrong with my code. RE: Please let me know what is wrong with my code.
Lynn Pettis
SSC Guru
Points: 442467
More actions
October 18, 2017 at 3:36 pm
#1964297
You really need to learn about books online. Your UPDATE statement was totally wrong.
UPDATE tv SET A = 1 - [tc].A , B = 1 - [tc].B , C = 1 - [tc].C , D = 1 - [tc].DFROM T_V AS tv INNER JOIN T_C AS tc ON tv.[Unique ID] = tc.[Unique ID];