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

                         and t1.Layer=t2.Layer                  

                         and t2.IsInSC <> 1                  

                         and t1.Qnty>0

                         and  t1.ProcCode not in(''''990'''',''''000'''')

                         and (( t1.PartNum >= @InBPartnum or @InBPartnum='''''''')

                                  and (t1.PartNum <= @InEPartnum or @InEPartnum=''''''''))

                         and ((t1.Revision = @InBRevision or @InBRevision ='''''''')

                                  and (t1.Revision = @InERevision or @InERevision =''''''''))

  End

/*生成出货状态时间格式以及完整性生成*/

Declare @Partnum varchar(20) , @Revision varchar(5) , @Count int , @DateCount int

Declare @WeekDate datetime , @Com varchar(200)

Select @Com =''''A''''

 DECLARE AddDateList INSENSITIVE CURSOR                                                                            

    FOR                      

          Select Partnum, Revision  From #WeekConfig

              Group by Partnum, Revision                             

  OPEN AddDateList                     

 << 上一页  [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