---定义开始和结束时间declare @st_dt datetimedeclare @en_dt datetime---时间赋值select @st_dt = '20150601'select @en_dt = '20150930' ---定义中间变量declare @dt datetimeselect @dt = @st_dt ---开始按照时间循环执行while @dt <= @en_dtbegin    ---这个是个演示，可以替换为需要执行的存储过程  DECLARE @Tel varchar(50),        @ID varchar(50)DECLARE Subscribe_Cursor CURSOR --定义游标FOR(    select top 360 CONVERT(VARCHAR(20),CONVERT(DECIMAL(20,0),F1)),id from SData where Tag=0)OPEN Subscribe_Cursor; --打开游标FETCH NEXT FROM Subscribe_Cursor INTO @Tel,@IDWHILE @@FETCH_STATUS = 0    BEGIN    insert into LS_ReCall(Tel,ReCallPlanDate)values(@Tel,@dt)    update SData set Tag=1 where id=@ID     FETCH NEXT FROM Subscribe_Cursor INTO @Tel,@ID;     ENDCLOSE Subscribe_Cursor; --关闭游标DEALLOCATE Subscribe_Cursor; --释放游标    ---中间变量加1    select @dt = DATEADD(DAY,1,@dt)    end---定义开始和结束时间declare @st_dt datetimedeclare @en_dt datetime---时间赋值select @st_dt = '20150602'select @en_dt = '20150930' ---定义中间变量declare @dt datetimeselect @dt = @st_dt ---开始按照时间循环执行while @dt <= @en_dtbegin      ---定义开始和结束工号        declare @st_code int        declare @en_code int        ---工号赋值        select @st_code =1        select @en_code = 18        ---定义中间变量        declare @code int        select @code = @st_code        while @code <= @en_code        begin                DECLARE @ID varchar(50)        DECLARE Subscribe_Cursor CURSOR --定义游标        FOR        (              select top 20 id from LS_ReCall where ReCallPlanDate=@dt and EmpCode is null        )        OPEN Subscribe_Cursor; --打开游标        FETCH NEXT FROM Subscribe_Cursor INTO @ID        WHILE @@FETCH_STATUS = 0            BEGIN            update LS_ReCall set EmpCode=@code where id=@ID            FETCH NEXT FROM Subscribe_Cursor INTO @ID;             END        CLOSE Subscribe_Cursor; --关闭游标        DEALLOCATE Subscribe_Cursor; --释放游标        ---中间变量加1       select @code = @code+1        end    ---中间变量加1    select @dt = DATEADD(DAY,1,@dt)    end