asked
Help Please!What is missing from this updat script?
USE [Staples POG Test] GO UPDATE Plano SET Desc3 = (SELECT message_line_6 FROM Spaceman.dbo.NSW WHERE Id = Name UPDATE Plano SET Desc4 = (SELECT segment_width/width FROM Spaceman.dbo.SECTION WHERE Id = Name UPDATE Plano SET Desc5 = (SELECT height FROM Spaceman.dbo.SECTION WHERE Id = Name UPDATE Plano SET Custom1 = (SELECT depth FROM Spaceman.dbo.SECTION WHERE Id = Name UPDATE Plano SET Custom2 = (SELECT width FROM Spaceman.dbo.SECTION WHERE Id = Name UPDATE Plano SET Custom3 = (SELECT segment_width FROM Spaceman.dbo.SECTION WHERE Id = Name
Do you want to update columns from different tables? For better understanding use some dummy column and table names instead of Column and Table keyword. It will help us to give a precise answer.
Yes I am using the Column and table for brevity and no I havnt posted the script more than once. This is the error Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'UPDATE'. USE [DB1] GO UPDATE tableA SET ColumnA = (SELECT columnA FROM DB2.dbo.tableA WHERE ID = Name UPDATE tableA SET ColumnB = (SELECT ColumnB FROM DB2.dbo.tableB WHERE Id = Name UPDATE tableA SET ColumnC = (SELECT ColumnC FROM DB2.dbo.tableB WHERE Id = Name UPDATE tableA SET ColumnD = (SELECT ColumnD FROM DB2.dbo.tableB WHERE Id = Name UPDATE tableA SET ColumnE = (SELECT ColumnE FROM DB2.dbo.tableB WHERE Id = Name
For that error I already told that there is a missing ")" after every "Name" column in your script. If you want to update from 2 tables, then amend your question to reflect which columns you need from which table.
Assuming you are using "column" and "table" keywords for brevity and mistakenly posted the script more than once, there is a closing parentheses ")" missing after the "Name" Column. Also are you sure that ID & Name have the same data type and are the intended columns to compare the values? Moreover, what error you are prompted with? EDIT: After re-formatting the question I realize that the OP wants to update multiple columns @callvey You can certainly update multiple columns in one update statement like UPDATE tableA SET ColumnA = [column], ColumnB = [column], ColumnC = [column], ColumnD = [column], ColumnE = [column], ColumnF = [column] FROM tableA INNER JOIN DB2.dbo.[TABLE] ON ID = NAME EDIT1: According to the latest information UPDATE Plano SET Desc3 = message_line_6 FROM Plano INNER JOIN Spaceman.dbo.NSW ON ID = NAME UPDATE Plano SET Desc4 = segment_width/width, Desc5 = height , Custom1 = depth , Custom2 = width , Custom3 = segment_width FROM Plano INNER JOIN Spaceman.dbo.SECTION ON ID = NAME
@callvey Glad to know that it helped. Would you mind accepting the answer then? It will help the future users as well ;)
8 People are following this question.
