declare @sql varchar(4000) set @sql = 'select 名称' select @sql = @sql + ',sum(case 门店 when '''+门店+''' then 数量 end) as '+门店 from (select distinct 门店 from CJ) as a set @sql = @sql+' from cj group by 名称' exec(@sql)
不懂!
