Hello.
I need to do a openquery to a linked server, and get record with id no in a sub select pointing to a table stored in SQLServer.
I have something like this:
select * into tmptable
from openquery (select * from linkedserverTable where id not in (select distinct(id) from sqlserverTable))
How to make sqserverTable not pointing to linked server, but sqlserver ?
Rgds
JCselect *
into tmptable
from openquery (linkedserver,'select * from linkedserverTable')
where id not in (select distinct id from sqlserverTable)
Showing posts with label pointing. Show all posts
Showing posts with label pointing. Show all posts
Subscribe to:
Comments (Atom)