Interested to Buy Any Domain ? << Click Here >> for more details...
How can we acheive Correlated sub-query in Designer?
- 2 Answers
- 15923 Views
- Infosys, TCCX, Wells Fargo, I also Faced
- E-Mail Answers
Answer Posted / prabha
A correlated subquery is a SELECT statement nested inside
another T-SQL statement, which contains a reference to one
or more columns in the outer query. Therefore, the
correlated subquery can be said to be dependent on the
outer query. This is the main difference between a
correlated subquery and just a plain subquery. A plain
subquery is not dependent on the outer query, can be run
independently of the outer query, and will return a result
set. A correlated subquery, since it is dependent on the
outer query will return a syntax errors if it is run by
itself.
| Is This Answer Correct ? | 5 Yes | 17 No |
Post New Answer View All Answers
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What is the difference between slice and dice and cross tab report?
How to restrict password to a user while sending a document in .pdf format
What are the data types present in bo? What happens if we implement view in the designer and report?
how to create metric universe ?
Explain is there any other repository domains rather than universe, security, document?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain what are the measure objects?
what is the difference b/w the refresh and buffered data?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
What is the difference between condition & filter?
Explain what are the steps to be taken to schedule the report?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
