pivot实现动态行转列

if object_id(‘tempdb…##MyTemp’) is not null
begin
DROP TABLE ##MyTemp --如果有存在就删除临时表
end

set @sql_str = ‘SELECT ProdId, ’ + @clos + ’ into ##MyTemp from
(
select ProdId
, Qty
, ProdDate
from A
) x
pivot
(
sum(Qty)
for ProdDate in (’ + @clos + ')
) p ’

execute(@sql_str)