不知道哪里有错误？谢谢！

[dyeerp]

declare @FID int,
@j int
select @j=max(FID) from Smp_EngMaterial
if isnull(@j,0)=0 select @j=10000
while exists((select 1 from Smp_EngMaterial where FID=@j) or (select 1 from Smp_EngineBill where FInterID=@j))
begin
set @j=@j-1
end
set @FID=@j

[jobine]

declare @FID int, 
        @j  int 
select @j=max(FID) from Smp_EngMaterial 
if isnull(@j,0)=0 select @j=10000 
while exists((select 1 from Smp_EngMaterial where FID=@j)) or exists(select 1 from Smp_EngineBill where FInterID=@j)
begin 
  set @j=@j-1 
end 
set @FID=@j

[pengxuan]

while exists((select 1 from Smp_EngMaterial where FID=@j) or (select 1 from Smp_EngineBill where FInterID=@j))
这句不应该这样用吧

[ybkenan]

while ( exists (select 1 from Smp_EngMaterial where FID=@j) or exists (select 1 from Smp_EngineBill where FInterID=@j) )

[fcuandy]

while exists(
             select 1 from Smp_EngMaterial where FID=@j
             union
             select 1 from Smp_EngineBill where FInterID=@j
           )