SQL Server结果集循环处理的避免游标处理方法

[sql]

结果集循环，避免使用游标的方法（游标的性能一般不好）：创建一个临时表：

[sql]

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 = @packageID

declare @i int

declare @j int

set @i = 0

select @j = MAX(ID) from @tempTable

begin tran---Rex

while @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

end

commit tran