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


Please Help Members By Posting Answers For Below Questions

Give some information on report bursting?

704


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1877


how to create reports on screech?

2215


How to schedule the report in b.o?

706


Explain about a time when you discovered a more efficient way to do a work task?

809






How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

862


How to restrict password to a user while sending a document in .pdf format

2007


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1764


What is difference between webi and infoview?

800


How many universes can be created in a project?

733


Explain when we use aggregate awareness function in designer?

732


Explain what are the steps to be taken to schedule the report?

791


what is xcelsius architecture?

4274


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4013


Can we configure two instances of CMS pointing to two different CMS system databases?

1660