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 审核日期'