Use While Loop for Inserting data into a Table in SQL Server example

Here's an example

DECLARE @UserIds TABLE (RowId INT, UserId INT) 
DECLARE @Table1 TABLE (UserId INT, CustomerId INT, City VARCHAR(100), [State] VARCHAR(100)) 

INSERT INTO @UserIds
SELECT 1, 6578
UNION ALL
SELECT 2, 1546
UNION ALL
SELECT 3, 7865



DECLARE @Counter INT, @TotalCount INT, @UserId INT
SET @Counter = 1

SET @TotalCount = (SELECT COUNT(*) FROM @UserIds)

WHILE (@Counter <=@TotalCount)
BEGIN
	SET @UserId = (SELECT UserId FROM @UserIds WHERE RowId = @Counter)

	INSERT INTO @Table1 (UserId, CustomerId, City, [State])
    VALUES (@UserId, 0, 'Miami','Florida')

	SET @Counter = @Counter + 1
	CONTINUE;
END

SELECT * FROM @Table1