select list of ids and print one by one using for loop

mayur pandit

6y2k

I want to select list of ids using select query and print one by one using for loop.

in for loop using id i want to insert that data in diffirant table.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaimin Shethiya6y ago
Hello Mayur,

can you please try to below code,
Trick #1
DECLARE @Cnt INT = 1, @TotalCnt INT = 0
CREATE TABLE #TempIds
(
Id INT NOT NULL
)
INSERT INTO #TempIds VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10)
SELECT @TotalCnt = COUNT(1) FROM #TempIds
WHILE(@TotalCnt >= @Cnt)
BEGIN
SELECT Id from #TempIds WHERE Id = @Cnt
SET @Cnt = @Cnt + 1
END
DROP TABLE #TempIds

Trick #2
CREATE TABLE #TempIds
(
Id INT NOT NULL
)
INSERT INTO #TempIds VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10)
WHILE (SELECT COUNT(1) FROM #TempIds) > 0
BEGIN
SELECT TOP 1 Id from #TempIds
DELETE FROM #TempIds WHERE Id = (SELECT TOP 1 Id from #TempIds)
END
DROP TABLE #TempIds

let me know if you want to other help needed.

Thanks
Harsh Gupta6y ago
You can directly insert in the table using the below query.
SELECT columns into TransactionTable from SourceTable
Otherwise, you can use the while loop as T-SQL doesn't have a FOR loop. You can refer below thread.
https://stackoverflow.com/questions/6069024/syntax-of-for-loop-in-sql-server