viw_price_history.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

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

create view viw_Price_History
as
select hpn,unitprice as  Unit_Price ,curunit as Currency,max(created_dt) as Creation_dt,max(last_upd_dt) as Modify_dt
from ord_item  where isnull(hpn,'')<>''
group by hpn,unitprice,curunit