改为:
exec('insert #t select a.pclass,count(pid)
from Tpclass a left outer join '+tbname+' b on
b.lid= '+@lid+' and b.pflag=''y'' and charindex(cast(a.pclass as varchar),b.pclass)>0
where a.lid= '+@lid+' and charindex(cast('+@pclass+' as varchar),fre)>0')
exec('insert #t select a.pclass,count(pid)
from Tpclass a left outer join '+tbname+' b on
b.lid= '+@lid+' and b.pflag=''y'' and charindex(cast(a.pclass as varchar),b.pclass)>0
where a.lid= '+@lid+' and charindex(cast('+@pclass+' as varchar),fre)>0')
from Tpclass a left outer join '+tbname+' b on b.lid= '+@lid+' and b.pflag=''y'' and charindex('',''+cast(a.pclass as varchar)+'','','',''+b.pclass+'','')>0
where a.lid= '+@lid+' and charindex('',''+cast('+@pclass+' as varchar)+'','','',''+fre+'','')>0')