Get each value from temp table without cursor

Ajay Mavatkar

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

3 Replies

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

Tapan Patel9y ago
This link gives information about what you can do.
http://stackoverflow.com/questions/18485502/sql-looping-temp-table-and-reading-data
+1
Ramesh Barik9y ago
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.
+1
Shakti Singh Dulawat9y ago
Can you share your temp table first three rows , do you have multiple values in single column ?
+1