I have query from SQL server 2000 which returns from database very large.
However I show client only 20 records per page. I need to find way which
allows to get from database only what I need (like top 100). Response from
database about 10mins which is not acceptable.

Look at this article for ideas about paging.

Paging Queries
www.aspfaq.com/2120


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Aleks Kleyn" <AleksKleyn (AT) OptOnline (DOT) net> wrote