troubleshooting Question

Named query in Visual studio

Avatar of Taras
TarasFlag for Canada asked on
Microsoft SQL Server 2008
1 Comment1 Solution416 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros