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 |
can u create report to connect oracle and sqlserver at a time?
Where will you find the address of repository in Business Objects?
How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is
Can you please send me the migration related issues .
Explain is data mart?
What do you mean by Object qualification?
What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.
what is xcelsius architecture?
How do u Receive requiremnts from the client?
Who launches the supervisor product in Business Objects for first time?