SQL Loop Example

sql-loop-example.sql

DROP TABLE IF EXISTS #temp
CREATE TABLE #temp (
       id INT IDENTITY (1,1)
       , org VARCHAR(50)
)
 
INSERT INTO #temp (org)
 
       SELECT 'aaa' UNION
       SELECT 'bbbb' UNION
       SELECT 'cccc' UNION
       SELECT 'dddd' UNION
       SELECT 'eeee'
 
--SELECT * FROM #TEMP
 
DECLARE @theOrg VARCHAR(50) = '';
DECLARE @cursorId INT = 1;
DECLARE @rowCount INT = ( SELECT COUNT(*) FROM #temp);

WHILE @cursorId <= @rowCount
BEGIN
 
   SET @theOrg = (SELECT org FROM #temp WHERE id = @cursorId);
   SELECT @theOrg
 
   SET @cursorId = @cursorId + 1
 
END