Until SQL server 2008's released, there’s no easy way to page reults or only show the first n results. I searched around for a while until I found this on MSDN.

SELECT TOP limitnumber
    FROM (
        SELECT TOP (limitnumber/ offset) * limitnumber) * 
        FROM tablename 
            AS T1 
            WHERE clauses 
            ORDER BY sortfield DESC) 
        AS T2 
        ORDER BY sortfield ASC;

The LIMIT and OFFSET values are the same as in PostgreSQL or MySQL. limitnumber is the number to show per page, and offset is the starting row.

MSDN Article