SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Named qry to join 2 tables from 2 DBs in a DSV
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kbarret3
Starting Member

Australia
1 Posts

Posted - 06/20/2013 :  01:53:24  Show Profile  Reply with Quote
Hi,
I'm looking for help with something that I believe should be possible to do in a data source view but am receiving an error for whenever I attempt it. My reading on the relevant content in MSDN (http://msdn.microsoft.com/en-us/library/ms175683.aspx )seems to back up my understanding that with the use of a named query I should be able to join two tables that exist in different data sources to create a new table in the data sourve view (DSV). The statement in the linked MSDN page suporting this is "A named query can also be used to join multiple database tables from one or more data sources into a single data source view table". It should be noted I am not having any problems using named queries to join tables that exist in the same data source.

Whenever I tried to do even the simplest named query to join two tables that exist in different data sources I receive an error that the first of the tables referenced can't be found. See the example in the picture below..



Has anyone successfully perfromed this task before or encountered this problems before? Any help would be appreciated.
Thanks in advance,

K.
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000