How to select data from 2 tables on 2 SQL servers

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

How to select data from 2 tables on 2 SQL servers

Author

Topic

parthi_dba
Starting Member

1 Post

Posted - 2008-09-21 : 04:55:58

Hi All,

Please help to correct this query to select data from 2 tables on 2 different servers using linked server

select SYS.Netbois_Name0 as ComputerName, SYS.AD_Site_Name0, SYS.Operating_System_Name_and0 as OperatingSystem,
as select * from OPENQUERY(test, select ENA.Name as UserName, ENA.Title, ENA.Department, ENA.TelephoneNumber,
ENA.PhysicalDeliveryOfficeName as OfficeName from dbo.v_enabledusers ENA) join V_R_System SYS
on SYS.UserName0=ENA.sAMAccountName where SYS.Operating_System_Name_and0='Microsoft Windows NT Workstation 5.1'
order by SYS.Netbois_Name0

Am I using right way to join the tables. Please advice any other method to join the tables.

BR,
Parthi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-21 : 04:59:48

modify like below:-

select SYS.Netbois_Name0 as ComputerName, 
SYS.AD_Site_Name0, 
SYS.Operating_System_Name_and0 as OperatingSystem,p.*
FROM( select * from OPENQUERY(test, 'select ENA.Name as UserName, ENA.Title, ENA.Department, ENA.TelephoneNumber, 
ENA.PhysicalDeliveryOfficeName as OfficeName from dbo.v_enabledusers ENA'))p
join V_R_System SYS 
on SYS.UserName0=p.sAMAccountName where SYS.Operating_System_Name_and0='Microsoft Windows NT Workstation 5.1'
order by SYS.Netbois_Name0

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources