Hi All,

This may belong in the database section, not sure. Anyway, I am selecting approx 1000 rows in a storedprocedure into a dataset using a dataadapter (sql Server 2k)

I know I can say "SELECT TOP 100 from etc" but what I wanna do is select records 100 to 200.

Is there a way to do this with sql/dataadapters? or are you gonna tell me to select the top 200 then advance 100?

I just didnt wanna waste me memory... unless anyone thinks selecting 1000 records will make hardly any difference...

thanks for any help

GaZ