结果集循环，避免使用游标的方法（游标的性能一般不好）：
创建一个临时表：
declare @tempTable table(ID int identity(1,1), unitID int, unitState int, partID bigint)insert into @tempTable select distinct u.id, u.UnitStateID, u.PartID from ffUnit u join ffUnitDetail ud on u.id = ud.unitID where ud.InmostPackageID = @packageIDdeclare @i intdeclare @j intset @i = 0select @j = MAX(ID) from @tempTablebegin tran---Rexwhile @i < @j begin set @i = @i+1 set @UnitID = null set @CurrUnitStateID = null set @PartID = null select @UnitID=unitID, @CurrUnitStateID = unitState, @PartID = partID from @tempTable where ID = @i exec @ret = objUNTCheckRouting @UnitID, @xmlPart, @xmlStation if @ret <> 0 or @@ERROR >0 begin if @@TRANCOUNT = 1 rollback else commit return @ret end endcommit tran