We have a cursor declared in a stored procedure.
While debugging this stored procedure, I noticed that if there are 10 rows (for example) satisfying the cursor criterion, when we loop through the cursor
data using "while @@sqlstatus =0", the cursor is looping for only 4 rows (for example).
So the cursor is not fetching all the rows satisfying the cursor criterion. Can any one explain this.
I hope I explained my issue clearly.