-- for each column in your sort, you need a variable to hold
-- the "starting values". In our case, we need two:

declare @startingDate datetime;

declare @startingID int;

-- again, we want to returns results from row @a to row @b:

declare @a int;

declare @b int;

set @a = 200 -- start at row 200

set @b = 250 -- end at row 250

-- get the starting date and starting ID to return results:

set rowcount @a

select @StartingDate = TransDate, @startingID = ID

from Data

order by TransDate ASC,ID ASC

-- find out how many rows to return, and set the rowcount:

set @b = 1 + @b - @a

set rowcount @b

-- now return the results:

select * from Data

where

TransDate > @StartingDate OR

(TransDate = @StartingDate AND ID >= @StartingID)

order by TransDate ASC, ID ASC

-- clean up:

set rowcount 0

 
The WHERE clause in the final SQL statement is the key, and it is good to be familiar with this type of clause even if you don't use this exact paging technique.  Look at it closely, and you will see it expresses logic to return rows within a certain range when that range is defined by more than 1 column.

For example, if you have a column called “YearMonth” with values in a YYYY-MM format, you can easily say:

WHERE YearMonth >= '2003-04'

But if you have two separate columns, one for Month and one for Year, you would express that same WHERE clause this way:

WHERE Year > 2003 OR (Year = 2003 AND Month >= 04)