END                                          

                     END                                         

   CLOSE AddDateList                                                                           

   DEALLOCATE AddDateList                           

/*生成交叉数据集*/

Insert Into #Stknwip( Partnum, Revision , Qnty, ProcCode , Id)

Select PartNum , Revision , Qnty , Com , ''''1A''''

 From #WeekConfig

Where WeekDate >= @BDateTime and WeekDate <= @EDateTime

Declare @StkPartnum varchar(20) , @StkRevision varchar(5) , @StkDelDate datetime , @StkUPP varchar(10)

 DECLARE CU_StknWip INSENSITIVE CURSOR                                                                           

    FOR                      

          Select Partnum , Revision  From #Stknwip  

           Group By  Partnum , Revision                    

  OPEN CU_StknWip                     

    BEGIN                                                                           

      FETCH NEXT FROM CU_StknWip INTO @StkPartnum , @StkRevision  

      WHILE @@FETCH_STATUS = 0

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