I have DB structure as follows,
Empcode,SoftwareName,Version --------Column Names
I need the Output as follows,
Empcode,Software(1),Version(1),Software(2),Version(2) ----Column Names(dynamically Creating according to number of records in DB for each empcode)
tmp001,vlc Player,Version10.0,SQL,Version 2005 -----Record of particular employee
If anybody have any idea pls post it..
Thanks in Advance,