Monthly Archives: March 2007

Sortable Paging Stored Procedure for SQL Server 2000 and SQL Server 2005

Scott Mitchell and Greg Hamilton posted an excellent example for a stored procedure to support paging on web sites in this article: http://www.4guysfromrolla.com/webtech/041206-1.shtml.   Here, I have taken their best example one step further and added support for sorting as well.  … Continue reading

Posted in SQL Server | 2 Comments