Solved

Named query in Visual studio

Posted on 2012-12-21
1
370 Views
Last Modified: 2013-03-01
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.
0
Comment
Question by:Taras
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 35

Accepted Solution

by:
YZlat earned 500 total points
ID: 38714484
The problem is exactly what it say - it is not supported. There is no problem with the query itself though
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question