p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 (http://p2p.wrox.com/forumdisplay.php?f=251)
-   -   Joining data from multiple data sources (http://p2p.wrox.com/showthread.php?t=47060)

ClaesR August 28th, 2006 09:30 AM

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.



All times are GMT -4. The time now is 12:45 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.