I have a table named frmRegistrationCSW.
I copied a group of records in the table to make duplicate records. When I did so I made a mistake and one of the columns did not get copied over. The column is named 'Sector' To fix the problem I setup the following code, but I know there are some issues. I get the error:
Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "R14.Sector" could not be bound.
SET R14.Sector = R13.Sector
WHERE ID IN (
FROM frmRegistrationCSW AS R13
INNER JOIN frmRegistrationCSW AS R14
ON R13.frmRegistrationCSWText2 = R14.frmRegistrationCSWText2
AND R13.frmRegistrationCSWText4 = R14.frmRegistrationCSWText4
AND R13.frmRegistrationCSWText5 = R14.frmRegistrationCSWText5
AND R13.fiscal = 2013
AND R14.fiscal = 2014
AND R13.Redetermination = 'Completed'
AND R13.[CSW/TitleXX] = 'B')