quote:

---

Originally posted by webfred

Take that fetch (inner)
FETCH NEXT FROM cCurLinkGroupNew INTO @varSerialNo,@varidentifierID

one time before the inner WHILE-statement
and one time before the inner END-WHILE

like you doing already in the outer loop

---

No, you're never too old to Yak'n'Roll if you're too young to die.

---

Declare cCurLinkNew Cursor For
Select distinct linkidentifierid from rs_identifier where pageTypeid=@PageTypeID and recordid=@RecordID 

OPEN cCurLinkNew

FETCH NEXT FROM cCurLinkNew INTO @varlinkidentifierid

PRINT 'OUTER LOOP START'

WHILE (@@FETCH_STATUS = 0) -- sql cursor fetch_status
BEGIN
 set @temp=0

----cursor to set continuous with page no----
 Declare cCurLinkGroupNew Cursor For
 select serialNo,identifierid from RS_Identifier where linkidentifierid=@varlinkidentifierid group by IdentifierID,serialNo
 OPEN cCurLinkGroupNew
 
 FETCH NEXT FROM cCurLinkGroupNew INTO @varSerialNo,@varidentifierID

 WHILE (@@FETCH_STATUS = 0)
 BEGIN
  

  PRINT 'INNER LOOP START'
  print 'swati'
  print @temp 
  print @varidentifierID

  if(@PageTypeID=28)
  begin
   Update RS_BillingSummary
   set ContinuousWP=@temp
   where IdentifierID=@varidentifierID
  end

  if(@PageTypeID=27)
  begin
   Update RS_VisitSummary
   set Continwithpage=@temp
   where IdentifierID=@varidentifierID
  end

  if(@PageTypeID<>27)
  begin
   if(@PageTypeID<>28)
   begin
    Update RS_Identifier
    set ContinuationWithPg=@temp
    where IdentifierID=@varidentifierID
   end
  end

 set @temp=@varSerialNo
 PRINT 'INNER LOOP'

 FETCH NEXT FROM cCurLinkGroupNew INTO @varSerialNo,@varidentifierID

 end-- inner while

CLOSE cCurLinkGroupNew
DEALLOCATE cCurLinkGroupNew

FETCH NEXT FROM cCurLinkNew INTO @varlinkidentifierid

PRINT 'OUTER LOOP'

End -- outer while

CLOSE cCurLinkNew
DEALLOCATE cCurLinkNew