"David D." <daviddiamond.remove-if-not-spam@comcast.net> wrote in message
news:bucprm$gitaf$1@ID-128035.news.uni-berlin.de...
> What are techniques for retrieving the first 100 rows of a result set; and
> then later retrieving the second 100 rows (starting the search from where
> the first 100 left off).
>
> I am doing an unindexed wildcard search "%<string>%".
>
> How would I accomplish this from
> (1) straight SQL (e.g., from the Query Analyzer), or
> (2) from an ASP page using VBScript?
>
> This sounds like a fairly common task, because I have seen datawindows and
> other software packages do it. The database has a huge number of rows,
so
> I cannot afford to start the search over from the top for each subsequent
> 100 rows of result set. Can you point me to any sample code?
>
> - David D.
>
>
>
>

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:OrPkj2W3DHA.540@tk2msftngp13.phx.gbl...
> http://www.aspfaq.com/2120
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>

"David D." <daviddiamond.remove-if-not-spam@comcast.net> wrote in message
news:bucprm$gitaf$1@ID-128035.news.uni-berlin.de...
> What are techniques for retrieving the first 100 rows of a result set; and
> then later retrieving the second 100 rows (starting the search from where
> the first 100 left off).
>
> I am doing an unindexed wildcard search "%<string>%".
>
> How would I accomplish this from
> (1) straight SQL (e.g., from the Query Analyzer), or
> (2) from an ASP page using VBScript?
>
> This sounds like a fairly common task, because I have seen datawindows and
> other software packages do it. The database has a huge number of rows,
so
> I cannot afford to start the search over from the top for each subsequent
> 100 rows of result set. Can you point me to any sample code?
>
> - David D.
>
>
>
>

"Vlad Vissoultchev" <wqweto@nospam.myrealbox.com> wrote in message
news:ukgVnXf3DHA.1392@TK2MSFTNGP11.phx.gbl...
> you might fint this previous post useful:
>
>
http://groups.google.com/groups?hl=bg&lr=&ie=UTF-8&oe=UTF-8&selm=OzkQuI9%24CHA.2328%40TK2MSFTNGP10.phx.gbl&rnum=5
>
> HTH,
> </wqw>
>