Table of Numbers

CREATE FUNCTION table_of_numbers (@min_number int, @max_number int)
RETURNS @t table (i int)
AS
begin
  declare @number_of_numbers int
  set @number_of_numbers = @max_number - @min_number + 1
  insert into @t values (0)

  declare @i int
  set @i = 1
  while @i < @number_of_numbers / 2 + 1
  begin
    insert into @t select i + @i from @t
    set @i = @i * 2
  end
  insert into @t select i + @i from @t where i + @i < @number_of_numbers
  update @t set i = i + @min_number

  return
end