摘要:[SQL] 將資料表內列的資料轉成欄位的資料
參考 : http://social.msdn.microsoft.com/Forums/zh-TW/240/thread/6b5658e6-34d1-46bd-9131-47fef81ca2bb/
完全地解決我的問題，在此記錄一下
另外因為需要時間上的排序，所以程式修改如下
SELECT Convert( char(10),WhichDate ,111) as WhichDate,[A] as A_Temp,[B] as B_Temp
FROM (
SELECT WhichDate,WhichItem,Temp FROM tblItemTemp
) AS p
PIVOT(
Sum(Temp) For WhichItem in ([A],[B])
) AS PVT
Order By WhichDate