Endless Loop

*** edited by: master4eva ***


Please enclose your code in </ code> tags (without the space between the "</" and "code"). This will make your code easier to read online; therefore, encouraging a response to be faster. It is to your own benefit for your question to be answered in future.





I have already done the editing to include the <code></ code> tags.


*********





I have a trigger that fires this stored procedure during an update event. But i think i am getting an endless loop. Any idea? Thanks in advance....


<code>


ALTER PROCEDURE TrigRetReqRecIDP1


@REID int





AS





Declare @RRID int


Declare @intREID varchar(20)


Declare @intIMID varchar(20)


Declare @RetValint


Declare cr cursor


for


select RRID from RequestRecords where REID=@REID and RRStatus = 'PE'


open cr





fetch next from cr


into


@RRID





while @@fetch_status = 0


Begin


select @intIMID = (select IMID from ImplementationGroup where ImGrpName = 'Help Desk')


insert into ImplementationTasks


(


IMID,


ITStatus,


ITStatusDate


)


VALUES


(


@intIMID,


'2',


GetDate()


)


SET @RetVal = @@IDENTITY


Update RequestRecords


set ITID = @RETVal, RRStatus = 'IA'


where REID = @REID and RRID = @RRID








end





close cr


deallocate cr








GO