MSSQL 2003 Pagination

/* 
 * The TOP value is the page count, the inner TOP value is where to start from.
 * All where and ORDER BY statements need to be the same
 */

SELECT TOP 50
id, lastAction, userAgent, sessionStartedAt, sessionEndedAt,

/* optionally get the total count for the filtered set */
(
    SELECT COUNT(id)
    FROM tbl_session_logs
    WHERE userAgent LIKE '%Firefox%'
) AS totalRecords

FROM tbl_session_logs
WHERE id NOT IN 
(
    SELECT TOP 50 id FROM tbl_session_logs
    WHERE userAgent LIKE '%Firefox%'
    ORDER BY id desc
)
AND userAgent LIKE '%Firefox%'
ORDER BY id desc