Answer / vamsi

Use Nested Derived Table

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.

Please Send to my e-mail Interview Questions With Answers , Technical Test Questions With Answers and Code Snippets Of Business Objects - Dev , Business Objects - Reporting Analysis .

3 Answers   AOL,

---

what is diff between Decode and case ? Give some Example?

2 Answers  

---

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

0 Answers  

---

Can i merge two dataproviders if they do not have common column?

3 Answers  

---

can u create report to connect oracle and sqlserver at a time?

2 Answers   Zensar,

---

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 Answers  

---

What three things do you consider to be the most important factors for a manager?

0 Answers  

---

what is prompt? Cascading prompt? Syntax

5 Answers   TCS,

---

How to implement LDAP authentication in BOE

1 Answers   Infosys,

---

Explain is there any other repository domains rather than universe, security, document?

0 Answers  

---

What is the difference between the prompt and cascading prompt

2 Answers  

---

what is meant by scorecards?

2 Answers   TCS,

---