动态SQL PIVOT：
create table temp( date datetime, category varchar(3), amount money)insert into temp values ('1/1/2012', 'ABC', 1000.00)insert into temp values ('2/1/2012', 'DEF', 500.00)insert into temp values ('2/1/2012', 'GHI', 800.00)insert into temp values ('2/10/2012', 'DEF', 700.00)insert into temp values ('3/1/2012', 'ABC', 1100.00)DECLARE @cols AS NVARCHAr(MAX), @query AS NVARCHAr(MAX);SET @cols = STUFF((SELECt distinct ',' + QUOTENAME(c.category) FROM temp c FOR XML PATH(''), TYPE ).value('.', 'NVARCHAr(MAX)') ,1,1,'')set @query = 'SELECt date, ' + @cols + ' from ( select date , amount , category from temp) x pivot ( max(amount) for category in (' + @cols + ') ) p 'execute(@query)drop table temp结果：
Date ABC DEF GHI2012-01-01 00:00:00.000 1000.00 NULL NULL2012-02-01 00:00:00.000 NULL 500.00 800.002012-02-10 00:00:00.000 NULL 700.00 NULL2012-03-01 00:00:00.000 1100.00 NULL NULL
