S_Kumar_S (2/8/2013)
HI AllIs it possible to run the MERGE statement using Openrowset or openquery? I tried with below statement:
You want to run this MERGE as a remote query on SERVER=MYSERVER.
The MERGE uses a linked server (SERVERXYZ) table as a source.
What server are you connected to when you run the openrowset query?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden