>declare >@Ctr int, >@stor_id int > >Set @ctr = 1 > >declare Temp1 cursor scroll > for > select > stor_id > from stores with (nolock) > >open Temp1 > >FETCH ABSOLUTE @Ctr FROM Temp1 INTO @stor_id > >WHILE @@FETCH_STATUS = 0 > BEGIN > > EXEC Proc2 > > set @ctr = @Ctr + 1 > > FETCH ABSOLUTE @Ctr FROM Temp1 INTO @stor_id > print '---------------------------------' > print 'sp1 ' + convert(char,@ctr)+convert(char,@@FETCH_STATUS) > END > >CLOSE Temp1 >DEALLOCATE Temp1 >