Dynamic Column Generation
Hi All,
I have a table like this and i need to display the data as in Point 2).
Can you guys please help? We need this for one of our application. Number of record per day 15000 records per day.
Point 1)
Transaction id Product id Serial number Reason
100 1 123456 ABCD
100 1 XYZR
100 1 222222
200 2 8768 GHFR
200 2 JAYEN
200 2 9876 AMRA
200 2 9999
The above data should be shown as shown below :
Point 2)
Transaction id Product id Serial number1 Serial number2 Serial number3 Serial number4 Reason1 Reason2 Reason3 Reason4
100 1 123456 222222 ABCD XYZR
200 2 8768 9876 9999 GHFR JAYEN AMRA
Thanks in Advance to all.