SQL Server - For/While Loop example

T-SQL doesn't have a FOR loop, it has a WHILE loop

WHILE (Transact-SQL)

WHILE Boolean_expression
BEGIN

END

USE <YourDatabaseName>

GO 

DECLARE @inc INT;

SET @inc=1;
WHILE (@inc<=10) 

BEGIN 

print 'inside a while loop'
SET @inc = @inc +1 

END;

PRINT 'Done WHILE LOOP';

GO

------------Another Example



USE MyDatabase
GO
DECLARE @inc INT;

SET @inc=100;

DECLARE @date1 Date;


SET @date1=GETDATE();

WHILE (@inc>=1)
BEGIN
SET @date1= DATEADD(DAY,-@inc, GETDATE());

print 'inside a while loop';

print @date1;

WITH TEMP as
  ( SELECT *
   FROM Table1
   WHERE ID IS NULL
     AND dateupdated=@date1),
  temp2 AS
  (SELECT *
   FROM Table2
   WHERE 1=1
     AND date2=@date1 )
SELECT *
FROM TEMP a
INNER JOIN table2 e
ON e.ID=a.ID

EXCEPT

SELECT *
FROM temp2 a
INNER JOIN table4 e
ON e.ID=a.ID;


SET @inc = @inc - 1;
END;

PRINT 'Done WHILE LOOP';

GO