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.
Need to implement the logic
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Re: Need to implement the logic
try vertical pivot.
serach the forum you will get it
serach the forum you will get it