SQL Server 2k does not appear to support the LIMIT clause.

This should seek to the 10th record in the result and return only five records:

SELECT fields FROM table LIMIT 10,5;

How is that accomplished in SQL Server? "TOP" appears to support only the second part of the LIMIT clause, "return only X records".