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.