Named query in Visual studio

Taras
Taras used Ask the Experts™
on
I am  using  Microsoft t Visual Studio  2010 In process of creating Cube based on SQL Server 2008 platform.
 I created data source then data source view and put in several tables that went ok.
Then I was trying to add -  create Named Query in data source view  .
In query I am using Left outer apply  to call  function. This function is table - valued function.
Query is created
When I double click on this query I got this error popped up:
 SQL Syntax Error Encountered
The following errors were encountered while parsing the contents of SQL pane:
“The OUTER APPLY SQL construct or statement is not supported.”
However, If I right  click on it and  click on explore data I can see data.
How to get read of this error.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The problem is exactly what it say - it is not supported. There is no problem with the query itself though

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial