-
MERGE statement not working...
I am trying to update a table with another table when any rows are missing. I tried the MERGE command, but I get the following error:
MERGE INTO Genentech_test.EDSVisitSchedule
USING Persia.Genentech.EDSVisitSchedule
ON Genentech_test.EDSVisitSchedule.order = Persia.Genentech.EDSVisitSchedule.order
WHEN NOT MATCH THEN
INSERT VALUES(Persia.Genentech.EDSVisitSchedule.order, Persia.Genentech.EDSVisitSchedule.value)
Incorrect syntax near the keyword 'INTO'.
After doing some research, I found out that the 'INTO' of the MERGE command is not supported in SQL Server 2005. Does anyone have any alternatives for this?
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|