April 17, 2006 at 10:00 am
Hello,
I'm in a situation where I need to run querries from multiple servers. I need an example of how to fully qualify the location of the table/fields with Server.Database.dbo.TableName.Field. I can't put my finger on the location in BOL as to how to fully qualify the names, but I think it works as I just demonstrated.
Please provide an example as to how I would do this. Thank you for your help!
CSDunn
April 17, 2006 at 10:13 am
The way I do it is to alias the table and use the standard conventions.....ie...
Select A.Field1
, A.Field2
, A.Field3
, B.Field1
From Server.Database.dbo.TableName A
Inner Join Server.Database.dbo.TableName B
On A.Field1 = B.Field1
and so forth....
I would make mention that if you are doing cross server queries, try to consolidate your results prior to pulling them across the network.....
April 17, 2006 at 10:18 am
BOL help could be found under "distributed queries"...
**ASCII stupid question, get a stupid ANSI !!!**
April 20, 2006 at 11:10 am
Thank you for your help!
CSDunn
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply