像这样吗?
SELECT
BookID, Price, ISBN, Pages
FROM
(
SELECT BookID, Key, Value FROM yourTable
)
AS SourceTable
PIVOT
(
SUM(Value) FOR Key IN (Price, ISBN, Pages)
)
AS PivotTable
ORDER BY
BookID
http://technet.microsoft.com/zh- cn/library/ms177410(sql.105).aspx