SQL动态生成列

数据表ProductSales如下：

现要实现如下效果：

思路如下（主要是拼接查询字符串）：

创建存储过程：SaleReport

Create procedure SaleReport
as
begin
 declare @sql varchar(8000)
 set @sql = 'select Date'

 select @sql = @sql + ',isnull (sum(case Product when '''+Product+''' then SaleSum end),0) as ['+Product+']' 
 from (select distinct Product from ProductSales) as a

 select @sql = @sql+' from ProductSales group by [Date]'
 exec(@sql)
end

运行结果如下：

exec SaleReport

参考：https://www.cnblogs.com/ShaYeBlog/p/3594517.html