Update with change of setpoint
How can we write a sql update statement that will update the records and change the "set" value every time?
For example: If we have records like this
SomeNumber SomeV CurCode WhatCodeShouldBe
200802754 432 B08 B09
200802754 432 B08 B09
200802754 432 B08 B09
200808388 714 64B C00
200804119 270 64B C00
I want to update every "SomeNumber" record so that "CurCode" is the same as "WhatCodeShouldBe"
Thanks for any help!
update a
set
3rdColumn = b.2ndColumn
from
tableA a
inner join tableB b
on a.linkToB = b.linkToA
Based on your new comments
UPDATE yourtable SET CurCode = WhatCodeShouldBe
UPDATE tableName SET CurCode = WhatCodeShouldBe
Assuming the new code is stored in a different column i.e. WhatCodeShouldBe
, in the example above, the expression looks something like this:
UPDATE table SET CurCode = WhatCodeShouldBe
replacing the names of the actual columns. This is essentially what the DBMS says, "for each row, set a code column regardless of the value in that other column for each row."
I have this data, creating some confusion and gathering information from different tables. :( Updating this temp table will not help ... I need to be able to push the changes back to the original table. I will try to give a better example ...
Table A: 200802754 432 B08 200802754 432 B08 200802754 432 B08 200808388 714 64B 200804119 270 64B
Table B 432 B09 432 B09 432 B09 714 C00
So, I want to make the 3rd column of the table the same as the second column of table B ... joining the tables in column 2. 200804119 270 64B C00