SELECT kp_order_number, kp_codeand_color AS kp_item_code , kp_yltype_name AS '类别' ,kp_item_name as '名称' ,kp_item_size as '规格' ,kp_color as '颜色', kp_unit_no as '单位',kp_waster as '损耗',kp_waster_qty
into #t FROM jb_fw_detail a ,jb_bagyltype b
WHERE (a.kp_type_id=b.kp_yltype_no)
AND kp_sheet_no=@sheetno
--ORDER BY b.kp_order_number
declare @sql varchar(8000)
set @sql = 'select 类别 ,名称 ,规格 ,颜色, 单位,损耗 '
select @sql = @sql + ', sum(case kp_item_code when '''+kp_item_code+''' then kp_waster_qty else 0 end) ['+kp_item_code+'] '
from (
select distinct kp_item_code from #t
) as a
set @sql=@sql+' from #t group by 类别 ,名称 ,规格 ,颜色, 单位,损耗 ,kp_order_number order by kp_order_number '
exec(@sql)
drop table #t