Need to implement the logic
Posted: Fri Jul 15, 2011 4:44 am
Hi
I have source date like this
for eg:
ID NEW VERSION NAME NO
100 1 V ABC 2004
100 1 V XYZ 20
100 1 V PQR P
200 1 V ABC 2005
200 1 V XYZ 30
200 1 V PQR Q
I required below out put.
ID NEW VERSION ABC XYZ PQR
100 1 V 2004 20 P
200 1 V 2005 30 Q
Can you please guide me the how to implement this senerio.
I have source date like this
for eg:
ID NEW VERSION NAME NO
100 1 V ABC 2004
100 1 V XYZ 20
100 1 V PQR P
200 1 V ABC 2005
200 1 V XYZ 30
200 1 V PQR Q
I required below out put.
ID NEW VERSION ABC XYZ PQR
100 1 V 2004 20 P
200 1 V 2005 30 Q
Can you please guide me the how to implement this senerio.