SQL Server For Each Row Next

gistfile1.sql

-- from: http://sqlserverplanet.com/tsql/sql-server-for-each-row-next

SELECT
    RowNum = ROW_NUMBER() OVER(ORDER BY CustomerID)
    ,*
INTO #Customers
FROM SalesLT.Customer
 
DECLARE @MaxRownum int
SET @MaxRownum = (SELECT MAX(RowNum) FROM #Customers)
 
DECLARE @Iter int
SET @Iter = (SELECT MIN(RowNum) FROM #Customers)
 
WHILE @Iter <= @MaxRownum
BEGIN
    SELECT *
    FROM #Customers
    WHERE RowNum = @Iter
 
    -- run your operation here
 
    SET @Iter = @Iter + 1
END
 
DROP TABLE #Customers