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

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

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

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

鄂公网安备 42011102001154号

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