Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Named qry to join 2 tables from 2 DBs in a DSV

Author  Topic 

kbarret3
Starting Member

1 Post

Posted - 2013-06-20 : 01:53:24
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 ([url]http://msdn.microsoft.com/en-us/library/ms175683.aspx [/url])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.
   

- Advertisement -