高手看看
帮帮忙改错!
declare @sql varchar(8000)
set @sql = 'select jhbh'
select @sql = @sql+ ',sum(case wzbh when ''left(wzbh,2) = 'A6'and left(jhbh,6) = '200312''' then jhsl else 0 end) ['+wzbh+']'
from (select distinct wzbh from jhxx_clf) as wzbh
select @sql = @sql+' from jhxx_clf group by jhbh'
exec(@sql)
怎么不对呢?
谢谢!!!!!