you can use PIVOT clause for this.
http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx[
^]
for ex:
SELECT *
FROM (
SELECT *
FROM [Tb_SCh_TIme_Table ]
) P
PIVOT (
MAX([faculty_code])
FOR [session] IN ([1],[2],[3] ,[4])
) AS PVT
WHERE course='PH2'
above code will give you the output as below
date course 1 2 3 4
---------- ------ ----- ----- ----- -----
2013-01-14 PH2 NR NULL CM NR