More with SQL Server 2005 : Top n Per Group, Paging, and Common Table Expressions

declare @startrow int
declare @endrow int

set @startRow = 40
set @EndRow = 70

with MasterRowNums as
(
select m.nameLast, m.nameFirst, m.lahmanID,
ROW_NUMBER() over (order by m.nameLast, m.nameFirst, m.lahmanID) as RowNum
from [master] m
)
select
MasterRowNums.*
from
MasterRowNums
where
RowNum between @startRow and @endRow
order by
nameLast, NameFirst, lahmanID