SQL Server从记录创建标题字段

只是因为我没有看到动态枢轴

例

Declare @SQL varchar(max) = '
Select *
 From  YourTable A
 Pivot (sum([Amount]) For [StockName] in (' + Stuff((Select Distinct ','+QuoteName(StockName) 
                                               From  YourTable A  
                                               Order By 1 
                                               For XML Path('')),1,1,'')  + ') ) p'
--Print @SQL
Exec(@SQL)

退货

Name    Product 1   Product 2   Product 3
John    40          20          NULL
Mary    10          50          9