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?
In banking domain how many Fact tables,Dimension table are present?
how many reports have u created ? explain a few.
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
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??
Explain about a time when you discovered a more efficient way to do a work task?
Explain what is the difference between slice and dice and cross tab report?
How were the reports scheduled and how to resolve unexecuted documents?
what is the difference b/w the refresh and buffered data?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
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,
Explain is data mart?
When we use aggregate awareness function in designer?
Can you please send me the migration related issues .
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN