Answer / san

It's not at all possible to create duplicate columns in a
SQL table. The how can we delete the duplicate columns?

Answer / sathyasheelanbe

delete from tablename where rowid not in(select max(rowid)
from tablename group by primary key columnname)

Answer / subash

In this query the values will delete based on employee names

delete from emp a1 where rowid<(select max(rowid)from emp a2
where a1.ename = a2.ename group by a2.ename having count(1) >1);

when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report

2 Answers  

---

What is object stores?

0 Answers  

---

Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance

1 Answers  

---

how to test reports in businessobjects?

8 Answers   TCS,

---

1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?

2 Answers   Mphasis,

---

How to create predefined filters in B.O.

2 Answers   TCS,

---

What are the traps ? What are the disadvantages of traps?

5 Answers   Wipro,

---

What are the advantages of setting up LOVs in the Universe?

2 Answers   Cap Gemini, Deloitte,

---

How to create a report template BO XI R2

2 Answers   Infosys, LBM,

---

Difference between scope of analysis in webi and in deski?

1 Answers   CA,

---

When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?

2 Answers   TCS,

---

every alternative row should be hilighted ? how u can ?

1 Answers  

---