When using OPENQUERY you will sometimes want to make calls to the same server you are working from. The most common reason for this is to query the output of a stored procedure into a temporary table.
For that example, follow this link: (Insert Results of Stored Procedure Into Table)
Before doing that you will have [...]
Archive of posts tagged OPENQUERY
Local Linked Server
Insert Results of Stored Procedure Into Table
Retrieving the result set from a stored procedure has historically proven to be a difficult task. Fortunately with the advent of OPENROWSET, our life as developers has become much simpler. Using openrowset is very simple when we do not have procedures that take parameters, However when parameters become involved the game changes, however [...]