viw_gl_price_history.sql

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

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

create view GL_Price_history
as
select (select count(*) from viw_Price_History where hpn = a.hpn and unit_Price<=a.Unit_Price) as Item,
a.hpn,a.unit_Price,a.Currency,a.Creation_dt,a.Modify_dt
from  viw_Price_History a