title: Can we run MERGE Statements if the source and destination databases are on different servers
body: <p>The title is the question. Will be very helpful if some one can also point to a link if at all it is possible.</p>
  
  <p>And also, can we use a CTE in the Merge statement? Or we need to think of an alternative like temp table or table variable?</p>