Listing 3: Code That Creates and Populates an Auxiliary Table of Numbers
SET NOCOUNT ON;
IF OBJECT_ID('Nums') IS NOT NULL
  DROP TABLE Nums;
GO
CREATE TABLE Nums(n INT NOT NULL);
DECLARE @max AS INT, @rc AS INT;
SET @max = 1000; -- revise max number according to your needs
SET @rc = 1;

BEGIN TRAN
  INSERT INTO Nums VALUES(1);

  WHILE @rc * 2 <= @max
  BEGIN
    INSERT INTO Nums SELECT n + @rc FROM Nums;
    SET @rc = @rc * 2;
  END

  INSERT INTO Nums
    SELECT n + @rc FROM Nums WHERE n + @rc <= @max;
COMMIT TRAN

ALTER TABLE Nums ADD CONSTRAINT PK_Nums PRIMARY KEY(n);