How can we acheive Correlated sub-query in Designer?
- 2 Answers
- 15207 Views
- Infosys, TCCX, Wells Fargo, I also Faced
- E-Mail Answers
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
How many universes can be created in a project?
Explain the data types present in bo and what happens if we implement view in the designer and report?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain about a tricky situation for which you found a very simple solution?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
How would you format some text using css to be verdana and bold?
Explain in detail about type 1?
What is package in BO
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
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
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
how to create reports on screech?
