Your question, your audience. Choose who sees your identity—and your question—with question security.
Named query in Visual studio
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.
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.
Asked:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now