asked on 9/12/2013

insert a column record within the same table between two "identical" records

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.

Help please!

      
UPDATE frmRegistrationCSW
SET R14.Sector = R13.Sector
WHERE ID IN (
SELECT R13.ID
   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')

Open in new window

Microsoft SQL Server 2008 Microsoft SQL Server

Last Comment

Kyle Abrahams, PMP

9/13/2013

Kyle Abrahams, PMP

9/12/2013

UPDATE R14
SET R14.Sector = R13.Sector
from frmRegistrationCSW R14
INNER JOIN frmRegistrationCSW AS R14
frmRegistrationCSW AS R13
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'
AND R13.ID = R14.ID

al4629740

9/12/2013

ASKER

Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'frmRegistrationCSW'.