sybase while循环

/*
使用while，调度过程
*/
DECLARE @A1 INT,@A2 INT,@DT DATE,@DT2 DATE

SET @DT2=‘2020-04-01’
SET @A1=1
SET @DT=CONVERT(DATE,@DT2)
SET @A2=DATEDIFF(DAY,@DT,CONVERT(DATE,GETDATE()))

        WHILE @A1<=@A2
           BEGIN  
               EXEC PROC_XXX  @DT2 
			   SET @A1=@A1+1
			   SET @DT2=DATEADD(DAY,1,@DT2)
           END