SQL Server Batch Writter

SqlBatcWritter.sql

IF OBJECT_ID('dbo.Nums') IS NOT NULL
  DROP TABLE dbo.Nums;
GO
CREATE TABLE dbo.Nums(n INT NOT NULL PRIMARY KEY);
DECLARE @max AS INT, @rc AS INT;
SET @max = 1000000000;
SET @rc = 1;

INSERT INTO Nums VALUES(1);
WHILE @rc * 2 <= @max
BEGIN
  INSERT INTO dbo.Nums SELECT n + @rc FROM dbo.Nums;
   SET @rc = @rc * 2;
 END

 INSERT INTO dbo.Nums
   SELECT n + @rc FROM dbo.Nums WHERE n + @rc <= @max;

 DECLARE @s AS DATETIME, @e AS DATETIME;
 SET @s = '19800101';
 SET @e = '21061231';

 SELECT @s + n - 1 AS dt
 FROM dbo.Nums
 WHERE n <= DATEDIFF(day, @s, @e) + 1;
 GO