Can any one tell me how can I make a function in Sql Server 2000 which give the records page wise.

If you have any reference or resource then please share it.

Please search on google, you should find a lot. I need to search into my archive. Will post it here, if I find...

_________________________
- Vijay G
Strive for Perfection

Basicall Many tehcniques are there. I know some. But I need the best one. I am not able to decide which one is better.

I know some like

stored procedure paging using temp tables

or

the ROW_NUMBER function

Here is a great solution to use.
The different options available with SQL SERVER 2000 and 2005 are discussed. Not every company has 2005. Some are still on SQL7.0

I read about 2005 techniques, but stick to the 2000 methods.

http://msdn2.microsoft.com/en-us/library/bb445504.aspx