Answer / ruchi

A PIVOT TABLE ALLOWS US TO REORGANIZE AND SUMMARIZE
SELECTED COLUMNS AND ROWS OF DATA IN A SREADSHEET.

Answer / 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

To find the current recordposition in data control.

0 Answers  

---

What is the statement to extract 4 characters from the middle of a string?

1 Answers  

---

What is ODBC Direct and Microsoft Jet Database Engine ?

0 Answers  

---

What are the record set types?

1 Answers  

---

Why can't I use an index with my VB accessed database?

0 Answers  

---

what database you used in project?

2 Answers   Satyam,

---

Write the correct order of execution of following form?s events: initialization, Load, Activate, Refresh , Paint

3 Answers  

---

What are the types of Instancing property that can be set for a Class in a ActiveX DLL and ActiveX EXE?

1 Answers  

---

How would you add elements and pictures to listitems in listview control?

0 Answers  

---

Can we change back color of command button control? if yes than how it is possible?

4 Answers   Wipro,

---

Is it possible to call backend procedures with ADO control?

1 Answers  

---

Explain the "cursortype" and "Locktype" in VB?

1 Answers  

---