Hi Mike,

Thanks for the response.

Actually, your are right. What I meant to say was after opening a cursor I want to issue a "FETCH ABSOLUTE intPos" to go to a specific record then return the next 100 entries form that cursor, rather than return the whole cursor and have ASP process it.

Any tips...

Thanks,
Mike


>>I am trying to get a result set via a stored procedure that declares a cursor and uses FETCH NEXT to populate the cursor.
>
>This isn't clear to me. Cursors are populated by the FETCH command. Cursors are populated when opened. The FETCH just moves the value of the current position to the variables specified.
>
>-Mike