pivot

WITH TEMP AS
(
    SELECT TOP 3 ROW_NUMBER() OVER(ORDER BY [Title]) AS [Row_Num],[Title]
    FROM [Message]
)
SELECT * FROM TEMP
pivot(
    max(title)
for Row_Num in([1],[2],[3])
)p


1    2    3
---- ---- ----
a    b    c

(1 行受影响)

 

原贴地址:http://topic.csdn.net/u/20101120/09/7e675b70-93be-47e2-9466-07400e3e19f0.html?87810