Select all records between two numbers using loop in SQL Server

Hi Shud,

Refer below query.

SQL

CREATE TABLE #tbl_test
(
    age INT,
    weight INT
)

INSERT INTO #tbl_test VALUES (3,5)
INSERT INTO #tbl_test VALUES (4,6)

CREATE TABLE #tbl_test_out
(
    age INT,
    weight INT
)

DECLARE @Counter INT
SET @Counter = 0

WHILE (@Counter <= 60)
BEGIN
	DECLARE @Weight INT
	SET @Weight = (SELECT Weight FROM #tbl_test WHERE age = @Counter)

	INSERT INTO #tbl_test_out VALUES (@Counter, @Weight)

	SET @Counter = @Counter + 1
	CONTINUE;
END


SELECT * FROM #tbl_test_out

DROP TABLE #tbl_test_out
DROP TABLE #tbl_test

Output

So on.