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

                        )

              Begin

                  Insert Into #WeekConfig(partnum, revision, qnty , weekdate , Com)

                                   Values(@Partnum , @Revision , 0 ,  convert(datetime, Convert(varchar ,  (@BDateTime + @DateCount), 101)),

                                           @Com+ Convert(varchar, @DateCount))  

                  Select @DateCount  = @DateCount + 1

              End

            Else

             Begin

              Update #WeekConfig Set  Com =  @Com+ Convert(varchar, @DateCount)

                          Where Partnum = @Partnum and Revision = @Revision

                  and  convert(datetime, Convert(varchar ,WeekDate , 101)) = @WeekDate

                            Select @DateCount  = @DateCount + 1

                       End

                 End

                 End

          FETCH NEXT FROM AddDateList INTO

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