)

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