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.