FETCH NEXT FROM AddDateList INTO @Partnum , @Revision
WHILE @@FETCH_STATUS = 0
BEGIN
Select @Count = Count(WeekDate) From #WeekConfig
Where Partnum = @Partnum and Revision = @Revision and WeekDate >= @BDateTime and WeekDate <= @EDateTime
Select @DateCount = 0
IF @Count < 7
Begin
While @DateCount < 7
Select @WeekDate = convert(datetime, Convert(varchar , (@BDateTime + @DateCount), 101))
IF Not Exists( Select * From #WeekConfig
Where Partnum = @Partnum and Revision = @Revision
and convert(datetime, Convert
<< 上一页 [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