... or by parameterizing the top statement maybe...

declare @i int

set @i = 1000

select top(@i) * from tablename order by ID