i written my code as follows;

See more:

C#

my query as follows;

select * FROM Tb_SCh_TIme_Table P PIVOT (MAX(Faculty_Code) FOR Session IN ([1],[2],[3] ,[4])) AS PVT  where course = 'PH2' order by date;

when i run my above query the output as follows;

 Date       Course      1      2      3     4

16/1/2013   PH2         GS
16/1/2013   PH2                             NR
16/1/2013   PH2                             CM

form my output i want the change as follows;

 Date       Course      1      2      3     4

16/1/2013   PH2         GS
16/1/2013   PH2                            NR,CM

i want the faculty CM in same line 16/1/2013 date.dont want to faculty code CM in Next Line..

from my query how can i do. to Get my output correct.what changes is needed from my above query.

help me please.