i tried both the query but it is not working please help me. i tried lot of times not getting output

See more:

SQL-Server

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]