How can we acheive Correlated sub-query in Designer?
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
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?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain how to schedule the report in b.o?
what is document design in boxi,have u participate in that
explain in detail about type 3?
Explain about a task that really tested your analytical abilities?
Explain about a tricky situation for which you found a very simple solution?
How to execute the plsql procedure from the report by clicking with mouse?
Explain the difference between union and group?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Give some information on report bursting?
Explain what are the steps to do to use alerts in bo?
What is the difference between the public object&schema object?
What is the difference between business requirement document and use case document.
what is xcelsius architecture?