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.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.