Answer Posted / prasanna s chitale

HI, GUYS

PIVOT TABLE IS ADVANCE FEATURE BY SQL ANSI WITH TRANSFORM
STATEMENT. THIS REPRESENTING THE DATA IN CONSOLIDATE WAY.
FOR EXAMPLE IF WE WANT THE PRODUCT V/S MONTHLY SALE ANALYSIS
THEN IT IS POSSIBLE WITH PIVOT TABLE.

MONTH APRIL-07 MAY-07 JUN-07
PRODUCT
MARUTI-800 700 800 550
MARUTI ZEN 100 120 90

ETC

THIS IS TYPICAL PIVOT TABLE

How do I do Peek and Poke and other low-level stuff?

1519

---

Explain the types of Views in Listview Control.

2866

---

What is meant by Establish Connection in RDO? 74.1s it possible to Access BackEnd procedures? Explain.

1552

---

How do you change the icon and otherwise manipulate the DOS box?

1549

---

What is Parser Bug?

2382

---

How do I create a window with a small title bar as in a floating toolbar?

1382

---

How would you create properties in ActiveX Control?

2030

---

How do you change the system menu (on the Control-Menu Box)?

1578

---

I get a "file not found" error on the IIF function when I distribute by program. Why?

1563

---

I have several megabytes of memory. Why do I get an "out of memory" error?

1612

---

How would you add elements in TreevieW Control.

2253

---

How to control the file?

1148

---

What is the use of Hyperlink control for DHTML applications?

2230

---

How can you get selected file from file system Control?

2055

---

Which type of object requires this object?

2043

---