row_number

with testtable as
(
 select loginid,row_number() over(order by loginid) as rownumber
from entree2awrp_text.dbo._en_user)

select * from testtable where rownumber between 12 and 18