>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.
This sounds like "paging". I use a table variable (SQL Server 2000) with an IDENTITY column to create the row number. Then a simple BETWEEN get the section of rows that are of interest. I was surprised as the speed that SQL Server can handle this.
-Mike