Linking to query in external data source on sql server

[Jacks]

I with to link to a query in another database using ODBC link to bring only
selected data back? Anyone know a way

 

[Rick Brandt]

I with to link to a query in another database using ODBC link to bring only
selected data back? Anyone know a way

Create a PassThrough query.

 

[Guest]

hi,
you might consider a remote query. that is a query in your
db that queries another db.
See this site for more info.
http://intra.whatuseek.com/query.go?
crid=51b357cc29ad8dce&query=remote+query