View Single Post
  #1 (permalink)  
Old August 28th, 2006, 09:30 AM
ClaesR ClaesR is offline
Registered User
Join Date: Aug 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Joining data from multiple data sources


We need to combine data from two different data sources (one ordinary SQL 2005 server and one reporting server). Typically we select a number of columns from one DB and then would like to join them with data from the other data source using a common key, producing a more coherent data view. There probably is an easy way to do this but we haven't found it yet.

I would very much appreciate any hint leading to a solution.