tr_更新最高限价

alter  trigger tr_更新最高限价 on t_supplyentry 
for update
as 

declare @FUsed int,@FOldUsed int 
select @FUsed = FUsed from inserted
select @FOldUsed= FUsed from deleted 

if update (FUsed) and @FOldUsed = 0 and @FUsed = 1  --采购价格管理审核时处理
begin 

update  a   set a.fpohighprice = b.fminprice from t_supply a
inner join (select fitemid,min(fprice) as fminprice from t_supplyentry  group by fitemid)  b  on a.fitemid = b.fitemid

where a.fitemid = b.fitemid 
    
     
end