viw_order_parts.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 15 行

if object_id('dbo.viw_Order_Parts') is not null
drop view dbo.viw_Order_Parts
go

create view viw_Order_Parts
as
select HPN,
Sum(Quantity) as Qty,
sum(received_Qty) as Rcv_Qty,
sum(Balance_Qty) as Outstd_Qty,
Max(deli_day) as Delivery_dt
from ord_item
group by hpn
go