viw_infor_record.sql

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

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

create view viw_Infor_Record
as
select distinct top 100 percent Item,hpn,cpn,mpn,vendor_id,vendor_nm,sug_vendor_id,sug_vendor_nm,Lead_Time from po_information_Record where isnull(hpn,'')<>'' and priority ='H'
order by hpn,vendor_id