m.mukesh.mca2009 (8/7/2014)
HiI have a table like below.
ID eIDinCountoutCount
417720NULL NULL
1000010331 7
1000010346 1
100001035NULL 1
1000010361 NULL
1000010362 NULL
1000010361 1
I want to table output like below
ID1033COUNT1033COUNT1034COUNT1034COUNT
417721761
100001761
100001761
Please help. Thanks
You have duplicate rows and duplicate columns in your sample output. Can you explain why? Or correct it to match what you really want.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.