--执行动态交叉表查询
declare @s varchar(8000)
set @s = 'select count(*) as 客户总数'
select
@s = @s+',['+rtrim(名称)+']=sum(case 名称 when '''+rtrim(名称)+''' then 1 else 0 end)'
from
#a
order by
aid
set @s = @s + ' from #b'
exec(@s)
declare @s varchar(8000)
set @s = 'select count(*) as 客户总数'
select
@s = @s+',['+rtrim(名称)+']=sum(case 名称 when '''+rtrim(名称)+''' then 1 else 0 end)'
from
#a
order by
aid
set @s = @s + ' from #b'
exec(@s)
declare @s varchar(8000)
set @s = 'select count(*) as 客户总数'
select
@s = @s+',['+名称+']=sum(case 名称 when '''+convert(varchar(20),名称)+''' then 1 else 0 end)'
from
#a
order by
aid
set @s = @s + ' from #b'
exec(@s)