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 to find the current record position in data control?

1969

---

What is data control in vb?

1016

---

What are the tools in visual basic?

1061

---

How do I change the color of a form in visual basic?

968

---

Data Control missing from toolbox when I use VB under NT3.5. Why?

1475

---

What is the use of parameters collection?

2469

---

What are the properties of datacontrol?

1958

---

what is the control used to call a windows application.

1993

---

How to down load image properties.

1069

---

How do I get the number of free bytes on a disk?

1687

---

How would you Create a Query Builder and Explain its uses

1983

---

How do I do drag & drop between applications?

1483

---

What is ActiveX Control?

2239

---

How do I force a file dialogue box to reread the currect disk?

1446

---

It possible to call OLEDB's Features directly in VB without using any control?

2376

---