Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-20 : 10:57:18
|
Brian writes "I am trying to write a query that will join a table from the default instance (SQL2K) and a table from a named instance on the same box. I know how to do this using ADO/OLEdB, is there a way to simply use the 4 part naming convention without setting up a linked server or using an OPENROWSET Function? Basically i wanted to know if there was some way to do the following:
select a.fname, a.lastname, b.member_no, b.salestotal
from tablea a JOIN Myserver\NamedInstance.database1.dbo.tableb b ON a.member_no = b.member_no
where b.salestotal > 1000
order by b.salestotal DESC
I receive an error using the '\' for the server name, wondered if there was a way around it..." |
|
|
|
|
|
Distributed T-SQL Queries with default & named instance