/*说明：
功能：订单材料统计表，统计指定订单范围的材料总用量。(物料编号，物料名称，用量，单位)
格式： exec pro_bom_sum 开始订单号，结束订单号
Build Date: 2009-04-16
Update date:
State: Finished
*/
if exists (select 1 from sysobjects where name ='pro_Bom_Sum' and type='p')
begin
drop procedure pro_bom_sum
create procedure pro_Bom_Sum
( @startOdrNo varchar(20)='%',
@endOdrNo varchar(20)='%'
)
as
begin
select t.matNo,m.mat_nm ,sum(t.mat_Qty) as mat_qty,t.Kcdw from (
select matNo,sum(mat_tqty) as Mat_Qty,kcdw from odr_sampleBom
where left(odr_no,9) between @StartOdrNo AND @EndOdrNo
GROUP BY MatNo,kcdw
union all
select a.matNO_jg,sum(a.plan_qty),b.kcdw from odr_sampleBom_jg a, odr_sampleBom b
where a.flowNo=b.flowNo and ( left(a.odr_no,9) between @StartOdrNo AND @EndOdrNo )
GROUP BY a.matNo_jg,b.kcdw
) t ,mat_material m where t.matNo=m.matNo group by t.matNo,t.kcdw ,m.mat_nm
order by t.matNo,t.kcdw
end
end
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/729024/viewspace-1020696/ ，如需转载，请注明出处，否则将追究法律责任。
