How can we acheive Correlated sub-query in Designer?
Answers were Sorted based on User's Feedback
Answer / 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 |
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
how can i add two different reports in the same document?
what is aggregate navigation?
3 Answers Countrywide, CTS, HCL,
Aliases and Contexts Which once will give the better performence when resolve the loops?
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
difference between xir2 and 6.5 version
Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?
. User wants to modify a report and wants to add additional data. How will you approach.
What is global filters and local filters
Hi friends, How many types of dimentions are they ?What are they? Thanks in advance
GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?
while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?