Paging in MSSQL?

Hi,
What is the best way to implement page-loading using sql server? How can I
load, say 10 records starting from the 1001st one?
DWHere are a few options:
http://www.aspfaq.com/show.asp?id=2120
ML
http://milambda.blogspot.com/|||> Here are a few options:
> http://www.aspfaq.com/show.asp?id=2120
Nice page, thanks ;-)
DW|||Don't forget to thank the guys at aspfaq:
http://www.aspfaq.com/credits.asp
ML
http://milambda.blogspot.com/