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

Question

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.

Jaimin Shethiya · Answer

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 Gupta · Answer

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

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

Answers (2)