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

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

Loop the SQL Result row by row

Loop the SQL Result

SQL