Pivot Table in SQL

create table #temp
(
EmpCode int null,
Att_Date datetime null,
Duration_HR int null,
Duration_Mn int null,
Remarks varchar(50) COLLATE Latin1_General_CI_AS null,
NoOfLeaves  int null
)

--Drop table #temp
Insert into #temp values(750,'10/1/2012',9,25,Null,0)
Insert into #temp values(751,'10/1/2012',8,50,'Late',0)
Insert into #temp values(752,'10/1/2012',9,8,'A',0)
Insert into #temp values(750,'10/2/2012',10,2,Null,0)
Insert into #temp values(752,'10/2/2012',8,0,'Late',0)
Insert into #temp values(753,'10/2/2012',Null,Null,Null,1)

--select * from #temp

SELECT col2,value
FROM
   (
   SELECT cast(EmpCode as varchar(50))as col1,convert(varchar(10),Att_Date,101) as col2
   ,cast(cast(Duration_HR as varchar(20)) + ':' + cast(Duration_Mn as varchar(20)) as varchar(50)) as col3,
   cast(NoOfLeaves as varchar(50)) as col6,
   isnull(Remarks,'')  as col7
   FROM #temp ) p
UNPIVOT
   (value FOR col IN
      (col1, col3, col7, col6)
) AS unpvt

drop table #temp