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 Linked Server