Thanks Sartori, I am new to this and have not done this before, if we go with the second option, are you suggesting to download the contents of the below query to tempdb database, that's on the server DPROSQL. How do I do that? and also do I have to the same thing for the 2nd query below, server FS3. If you could provide me step by step information that would be great
Select source_code, name, addr1, addr2, city, state_id, zip, phone FROM [dbo].[source_office]
order by source_code
Select Code, Name, ContactName, AddLine1, AddLine2, city, state, zip, PhoneNumber
FROM [dbo].[AcquiredFrom]
Order by Code