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

Hi!

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.

Cheers!

/Claes