large query

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@.OptOnline.net> wrote in message
news:DD4DE5D1-82EF-4E2A-A46A-7E8FB7407135@.microsoft.com...
>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.