T-SQL PIVOT row and column conversions

Previous examples:

Http://www.cnblogs.com/insus/articles/1969896.html

Http://www.cnblogs.com/insus/articles/1970577.html

Http://www.cnblogs.com/insus/articles/1970707.html

These are all examples of SQL Server row and column conversions or row conversions. However, at the beginning of the SQL Server2005 version, there is a new function pivot () that can be easily implemented. Refer to the following code:

SELECT [rid],[2011-01-23],[2011-01-24],[2011-01-25],[2011-01-26]
From
(
SELECT [rid],[dt],[hits] from [dbo]. [Recordhits]
) as P
PIVOT
(
SUM ([Hits]) for [DT] in ([2011-01-23],[2011-01-24],[2011-01-25],[2011-01-26])
) as Q;

Execution Result:

The other is to convert the above results into column rows:

SELECT [DT],[R1],[R2],[R3],[R4]
From
(
SELECT [rid],[dt],[hits] from [dbo]. [Recordhits]
) as P
PIVOT
(
SUM ([Hits]) for [RIDs] in ([R1],[R2],[R3],[R4])
) as Q;

Execution Result: