Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stan Kulp How to join a local table to a remote table by way of a linked server RE: How to join a local table to a remote table by way of a linked server

  • February 28, 2012 at 9:08 pm

    #1452897

    Don't have any experience with linked servers and wonder if anyone could clarify for me a question on the article's script? The article states:

    --POPULATE A TEMPORARY TABLE WITH DATA FROM THE LINKED SERVER

    SELECT StateProvinceID,StateProvinceCode

    INTO #temp

    FROM [SERVER02].[AdventureWorks].[Person].[StateProvince]

    GO

    --JOIN HOST SERVER TABLES WITH THE TEMPORARY TABLE

    SELECT a.FirstName,a.LastName,b.AddressLine1,b.City,c.StateProvinceCode

    FROM [SERVER01].[AdventureWorks].[Person].[Contact] a

    INNER JOIN [SERVER01].[AdventureWorks].[Person].[Address] b ON a.ContactID = b.AddressID

    INNER JOIN #temp c ON b.StateProvinceID = c.StateProvinceID

    GO

    In the above code the temp table #temp is being created on the local server Server01, right? Not on Server02, so the data is being moved to the local first?

    Also, in the second peice of code where the local/host server tables are joined to the temp table, presuming the temp table is on the local host server01 would the query really have to have the fully long justified server names (where SERVER01 is given)? Couldn't the syntax just start with [AdventureWorks].Person.Contact or even Person.Contact?

    Thanks for your help!