Answer / thanjairajan@gmail.com

The WITH clause may be processed as an inline view or resolved as a temporary table. The advantage of the latter is that repeated references to the subquery may be more efficient as the data is easily retrieved from the temporary table, rather than being requeried by each reference.

For example:

WITH dept_count AS (
SELECT deptno, COUNT(*) AS dept_count
FROM emp
GROUP BY deptno)
SELECT e.ename AS employee_name,
dc.dept_count AS emp_dept_count
FROM emp e,
dept_count dc
WHERE e.deptno = dc.deptno;

Answer / krishna

Specifies whether to send a request to the database using
an SQL WITH clause. When set to Yes, and if the database
supports WITH clauses, a WITH clause request is generated.
When set to No, or if the database does not support WITH
clauses, a request using derived tables is generated

How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.

5 Answers   HSBC,

---

Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar

2 Answers  

---

What are the main services provided by application tier?

0 Answers  

---

What are all the different types of prompt in cognos?

0 Answers  

---

Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos

2 Answers   IBM,

---

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

0 Answers  

---

What is the difference between drill down and drill through?

10 Answers   DELL, Deloitte, Systime,

---

how u create security to reports ????

10 Answers   iFlex, iGate,

---

-------------How to create a PortalTab?

1 Answers   Cap Gemini,

---

Define the cognos reporting tool?

0 Answers  

---

what is the difference between rollup aggregation and aggregation ?

1 Answers  

---

If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09

42 Answers  

---