SQL Error - can't see anything wrong!
Posted on 2016-09-15
I hope someone can help. I'm getting an error on the following code:
SELECT DISTINCT old_ssn
ALTER TABLE LFRD_Old_SSN_Cnt ADD SSN_SSNs nvarchar (255);
UPDATE A SET SSN_SSNs = B.SSN
FROM LFRD_Old_SSN_Cnt A LEFT OUTER JOIN LFRD B ON A.old_ssn = B.old_ssn;
The message is:
Msg 102, Level 15, State 1, Line 83
Incorrect syntax near ')'.
Line 83 is just after GO on the ALTER TABLE bit.
I can't for the life of me see what's wrong with the code. Please help.