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 |
|
ugh3012
Yak Posting Veteran
62 Posts |
 Posted - 2013-08-13 : 15:26:25
|
| I have two servers that are not linked; therefore, I cannot create a stored procedure (or any other kind of query) to join two table from two different servers. What would be a best way to get a list of IDs from one table and use it to get a list from another table. Below is a SQL I would have used if the two servers were linked. Select B.ID,Select A.Date,From ServerA A Inner Join Serber B B on A.ID = B.IDI created a staging table to pull data from two different servers into one table. I want to be able to do something like this. The result will be put into the staging table. Select A.DateFrom ServerAWhere A.ID in (User::ListID )User::ListID is name of package variable that contains the lists of IDs that was populated from Execute SQL task. |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-08-14 : 00:05:44
|
| If those two servers were liked, then you can use it directly...SELECT A.ID, A.DateFROM ServerA.DBName..TableA AWHERE A.ID IN (SELECT ID FROM ServerB.DBName..TableB)--Chandu |
 |
|
|
ugh3012
Yak Posting Veteran
62 Posts |
Posted - 2013-08-14 : 08:03:22
|
quote:
Originally posted by bandi
If those two servers were liked, then you can use it directly...SELECT A.ID, A.DateFROM ServerA.DBName..TableA AWHERE A.ID IN (SELECT ID FROM ServerB.DBName..TableB)--Chandu
They are not linked, so I cannot use this. I would had if it was linked. |
|
|
|
|
|
|
Two SQL servers are not linked