/ Published in: SQL
Loop the SQL Result row by row
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
DECLARE @links TABLE (idx SMALLINT PRIMARY KEY IDENTITY(1,1) , EnrolmentID INT) INSERT INTO @links (EnrolmentID) SELECT e.EnrolmentID FROM ProSolution.dbo.Enrolment e WITH (NOLOCK) -- Start the looping for each row in Temp table DECLARE @i INT DECLARE @numrows INT SET @i = 1 SET @numrows = (SELECT COUNT(*) FROM @links) --PRINT 'Number of Rows to Loop: ' + CONVERT(varchar(500), @numrows) IF @numrows > 0 WHILE (@i <= (SELECT MAX(idx) FROM @links)) BEGIN SELECT @EnrolmentID = EnrolmentID FROM @links WHERE idx = @i; -- Do something now -- INCREASE next one SET @i = @i + 1 END