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
Course Of The Month
9 days, 15 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Named query in Visual studio
Posted on 2012-12-21
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.
[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
Featured Post
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…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 15 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
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.