declare @s varchar(8000)
set @s = 'select 員工代號 = EMP_ID'
select @s = @s + ',['+ABS_NM+'] = sum(case when ABS_ID = '+rtrim(ABS_ID)+' then ABS_QT else 0 end)'
from 表A order by ABS_IDset @s = @s + ' from 表B group by EMP_ID order by EMP_ID'exec(@s)
set @s = 'select 員工代號 = EMP_ID'
select @s = @s + ',['+ABS_NM+'] = sum(case when ABS_ID = '+rtrim(ABS_ID)+' then ABS_QT else 0 end)'
from 表A order by ABS_IDset @s = @s + ' from 表B group by EMP_ID order by EMP_ID'exec(@s)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货