-- Get a range of numbers based on a tally table, the range can be 20bits wide
-- (1048576 positions) in this example.
declare @min bigint, @max bigint;
select  @min = 1000000000,  @max = 1000000200;

select top (@max - @min + 1) (@min - 1) + N from dbo.tally20b;

-- Get a range of numbers based on a tally table, the range can be 20bits wide
-- (1048576 positions) in this example. An interval of 10 is used.
declare @min bigint, @max bigint;
select  @min = 1000000000,  @max = 1000000200;

select top (@max - @min + 1) @min + (10 * (N - 1)) from dbo.tally20b;