declare @sql varchar(8000)
set @sql = 'select 审核日期,'
select @sql = @sql + 'sum(case when 车型='''+车型+''' and 颜色='''+颜色+'''
then 台数 else 0 end) as '''+车型+'/'+颜色+''','
from (select 车型,颜色 from 原结果集 group by 车型,颜色) as a
select @sql = left(@sql,len(@sql)-1) + ' from 原结果集 group by 审核日期'
declare @sql varchar(8000)
set @sql = 'select 分组的列,'
select @sql = @sql + 'sum(case Type when '''+Type+'''
then 求的数量列名 else 0 end) as '''+Type+''','
from (select distinct Type from table1) as a
select @sql = left(@sql,len(@sql)-1) + ' from table1 group by 分组的列'