Posted on: 5/8/2014 1:48:03 PM | Views : 308

I would like to convert the columns in to rows and rows in to columns.  Not all the properities but only output wise(display only).
There is a chance of having more columns with data.
My table is as follows:
ACID     DOT           TXNTYPE     SUM_OF_TRANS_AMOUNT
101      2014-05-08   CD                  750000
102      2014-05-08   CW                  900000

ACID:- ACCOUNT ID; DOT:- DATE OF TRANSACTION; TXNTYPE:- TRANSACTION TYPE;  TOTAL OF THE BALANCE IN THE ACCOUNT

ACID                                             101                         ...

Go to the complete details ...