date sess code course
14-Jan-13 1 CM AFF
14-Jan-13 3 CM AFF
17-Jan-13 1 NR CTF
from the above i want the output as follows;
AFF (course)
1 2 3 4 (sess)
14-Jan-13 CM CM
CTF (course)
1 2 3 4 (sess)
17-Jan-13 NR
for getting a above output i tried the query as follows; but output is not getting;
query as follows;
SELECT *
FROM (
SELECT *
FROM [Tb_SCh_TIme_Table])
PIVOT(MAX([faculty_code])FOR [session] IN ([1],[2],[3] ,[4])) AS PVT
i tired the above query when i run shows error as follows;
Line 5: Incorrect syntax near '('.
from my above query what is the mistake please help me.
[edit]Code block added (not that the original indentation makes it a lot clearer) - OriginalGriff[/edit]