open query

--****************************

--* Example 1

--* Import all users into new table

--*****************************/

SELECT *

INTO dbo.Users_Import

FROM OPENQUERY(remotelinkedservername, 'SELECT * FROM dbo.Users' )

--****************************

--* Example 2

--* Insert users that do not exist

--* into existing table

--*****************************/

INSERT INTO dbo.Users

(

UserID,

UserName,

FirstName,

LastName

)

SELECT

UserID,

UserName,

FirstName,

LastName

FROM OPENQUERY(remotelinkedservername, 'SELECT * FROM dbo.Users' ) ru

WHERE NOT EXISTS

(

SELECT 1

FROM dbo.Users

WHERE UserID = ru.UserID

)

--/****************************

--* Example 3

--* Insert results from remote procedure

--* into new table

--*****************************/

SELECT *

INTO dbo.List

FROM OPENQUERY(remotelinkedservername, 'set fmtonly off exec dbo.GetList')