Filas en Columnas con Pivote SQL Server 2008

[Libras]

Código SQL:

CREATE TABLE #temp
(
dato1 VARCHAR(20),
dato2 VARCHAR(20),
dato3 VARCHAR(20),
dato4 VARCHAR(20),
dato5 datetime,
dato6 INT
)
 
INSERT INTO #temp VALUES ('Form','V1.3','Clockspring','AB','2014-06-23',9)
INSERT INTO #temp VALUES ('Function','V1.3','Clockspring','AB','2014-05-05',4)
INSERT INTO #temp VALUES ('Function','V1.3','Clockspring','AB','2014-05-06',7)
INSERT INTO #temp VALUES ('Function','V1.3','Clockspring','AB','2014-06-09',5)
INSERT INTO #temp VALUES ('Function','V1.3','Clockspring','AB','2014-06-12',2)
INSERT INTO #temp VALUES ('Function','V1.3','Clockspring','AB','2014-06-17',1)
 
 
SELECT dato1,dato2,dato3,dato4,[2014-06-23],[2014-05-05],[2014-05-06],[2014-06-09],[2014-06-12],[2014-06-17] 
FROM
(
SELECT dato1,dato2,dato3,dato4,dato5,dato6 FROM #temp 
) AS sourcetable
pivot
(
MAX(dato6) FOR dato5 IN ([2014-06-23],[2014-05-05],[2014-05-06],[2014-06-09],[2014-06-12],[2014-06-17])
) AS pivote
 

saludos!