Get each value from temp table without cursor

Question

How can I get each value from the temp table in while loop so that I need to pass that each value to the insert query. I have a multiple values in tem table

Tapan Patel · Answer

This link gives information about what you can do. http://stackoverflow.com/questions/18485502/sql-looping-temp-table-and-reading-data

Ramesh Barik · Answer

BEGIN try begin tran IF OBJECT_ID('tempdb..#temptbl') IS NOT NULL BEGIN DROP TABLE #temptbl; END CREATE TABLE #temptbl(ID INT IDENTITY (1, 1), Col1 INT, col2 VARCHAR(20)) INSERT INTO #temptbl (Col1, col2) VALUES (1, 'A'), (2, 'B') DECLARE @Row INT WHILE ((SELECT COUNT(1) FROM #temptbl) > 0) BEGIN SELECT TOP 1 @Row = ID FROM #temptbl ORDER BY ID; INSERT INTO dbo.PhysicalTable (Col1, col2) SELECT Col1 ,Col2 FROM #temptbl WHERE ID = @Row DELETE FROM #temptbl WHERE ID = @Row END COMMIT END TRY BEGIN CATCH ROLLBACK END CATCH ------------------ Try this with out cursor . It may help you.

Shakti Singh Dulawat · Answer

Can you share your temp table first three rows , do you have multiple values in single column ?

Get each value from temp table without cursor

Answers (3)