This email was created by [your name] who thought you would be interested in the following Article:
"Pagination and Sorting in MS SQL Server 2000"
implementing pagination and sorting in MS SQL Server 2000 without using dynamic queries
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!