SQL 以日期动态更新维护的数据,一周排程时间日期设计

         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]  ...  下一页 >> 

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18