Create Table TPivot

(

    ID int identity(1,1),

    ProductName Varchar(20),

    SalesMonth int,

    SalesCount int

)

insert into TPivot Values

('Bicycle',1,1),

('Shoes',2,2),

('Clothes',3,3),

('Books',4,4),

('Medicine',5,5),

('Drinks',6,6),

('Shoes',7,7),

('Books',1,2),

('Bicycle',1,3),

('Medicine',1,4),

('Clothes',1,5),

('Mobile Phone',1,6),

('Books',1,7),

('Medicine',1,8),

('Shoes',1,9),

('Bicycle',2,10)

/****

SELECT 非透视列,

             [透视列 1] AS '列名1',

             [透视列 2] AS '列名2',

             [透视列 3] AS '列名3'

FROM (

        -- 源数据

        SELECT 非透视列,

               透视列值的来源列,

               需要聚合的值

        FROM 表

     )AS 别名

PIVOT

     (

        SUM(需要聚合的值)

        FOR 透视列值的来源列 IN ([透视列 1]，[透视列 2]，[透视列 3])

     )AS 别名

****/

Select ProductName,

Isnull([],0) As '',

Isnull([],0) As '',

Isnull([],0) As '',

Isnull([],0) As '',

Isnull([],0) As '',

Isnull([],0) As ''

From

(

    Select ProductName,SalesMonth, SalesCount From TPivot

) As Sales

Pivot

(

    Sum(SalesCount)

    For SalesMonth In ([],[],[],[],[],[])

) As PivotBL