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 remove/change the picture property of a control at design time?

1507

---

How can you filter out specific type of file using file system controls?

2113

---

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

1454

---

What is the need of tabindex property is label control.

1940

---

How to find size of the file. Which method or function is used to occomplish this?

1915

---

How can you force new objects to be created on new threads?

2290

---

___ property is used to change to ___ value to access a identity column'in datacontrols.

1557

---

How do you avoid the "Invalid use of null" error when reading null values from a database?

1628

---

how to make unlimited id(1rimjim,2rimjim,3rimjim....etc) login grp chat pogram for jabber?

2394

---

Explain OLE Drag and Drop?

2407

---

What is DAO?

1978

---

Can you create a Updatecascade, Deletecascade relation in Ms- Access?

2049

---

How come I get a "No Current Record" error when I use a a Data Control on an empty table?

1469

---

___,___ arguments will be used to run a executable program in shell function

1715

---

Types of LockEdits in DAO? 51 .Types of Recordsets.

1832

---