Generate Sequential Numbers

CREATE PROCEDURE GENERATEROWNUMBERS(@NUMBEROFROWS INT, @STARTNUMBER INT)AS BEGIN
DECLARE @NUMGEN TABLE (NUM INT)
DECLARE @CNT INT SET @CNT = 1
WHILE @CNT <= 100 BEGIN
INSERT INTO @NUMGEN
SELECT @CNT SET @CNT = @CNT + 1
END
SELECT @STARTNUMBER + ROWNUM FROM ( SELECT ROW_NUMBER() OVER (ORDER BY N1.NUM) AS ROWNUM FROM @NUMGEN N1, @NUMGEN N2, @NUMGEN N3, @NUMGEN N4 ) ROWNUMS WHERE ROWNUM <= @NUMBEROFROWS
END