------------修改维护数据, 方便时间限定范围-------------------------

Select top 0  Dateid,PartNum, Revision , TodayTime = DateId , Qnty = 0 , DateStr=''''Qnty10'''' ,Todate

 Into #ToDate

From Pdl_WeekProcedure

Declare @DayNum int , @CheckDate datetime , @StrInt varchar(8000)

Declare @PartnumDate varchar(20) , @RevisionDate varchar(5)

Set @CheckDate = Convert(datetime , Convert(varchar, getdate(), 101))

Set @StrInt = ''''''''

 DECLARE Cu_PartDate INSENSITIVE CURSOR                                                                            

    FOR                      

         Select Distinct PartNum, Revision From  Pdl_WeekProcedure       

  OPEN Cu_PartDate                     

    BEGIN                                                                           

      FETCH NEXT FROM Cu_PartDate INTO @PartnumDate , @RevisionDate  

      WHILE @@FETCH_STATUS = 0                                                                         

        BEGIN                                 

        Set @DayNum = 1

        While @DayNum <= 7

        Begin

 << 上一页  [11] [12] [13] [14] [15] [16] [17] [18] [19] [20]  ...  下一页 >>