this is my first post so please bare with me. If its something stupid please let me know and point to me to any links you think suitable.
I currently have a query to do some inner joins on multiple tables.
This is my sql Query im using
From dbo.cfg_person P
INNER JOIN dbo.cfg_login_info LI ON P.dbid = LI.person_dbid
INNER JOIN dbo.cfg_agent_login AL ON LI.agent_login_dbid = AL.dbid
INNER JOIN dbo.cfg_skill_level SL ON P.dbid = SL.person_dbid
INNER JOIN dbo.cfg_skill S ON SL.skill_dbid = S.dbid"
Unfortunately I will never know how many "name" 's that will be returned could be 1 upto 100
However when my data is returned it returns it to multiple rows like the following
Before - http://img832.imageshack.us/img832/2672/beforex.jpg
and i would like to add to columns dynamically like the following.
After - http://img823.imageshack.us/img823/1611/afterys.jpg
If you can help, thank you