Issues with cursor

Hi All,

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.

Regards,

Kiran