Wednesday, October 6, 2010

SQL-Server - Generalized Paging Query That Includes Sorting Clauses

SELECT TOP page_size * FROM table WHERE primary_key NOT IN
(SELECT TOP page_size * (page_number - 1) primary_key FROM table
WHERE filter_conditions
ORDER BY sort_field)
AND filter_criteria
ORDER BY sort_field

No comments: