请教在Cursor内更新表的问题

[xuhaoumsl]

从@OrderPlanPauseTable 里面看得值是正确的 不知道为什么实际表中数据都被更新成了和一样的数据 不知道哪里写错了

Open OrderPlanPauseCursor
FETCH NEXT FROM OrderPlanPauseCursor INTO @iScheduledID,@iOrderPlanID,@ScheduledDate,@DeliveredCnt
WHILE (@@FETCH_STATUS=0)
BEGIN

if @DeliveredCnt=0
Set @NewDate=DATEADD(dd,@iPauseDays,@ScheduledDate)
else
Set @NewDate=@ScheduledDate

INSERT INTO @OrderPlanPauseTable VALUES(@iScheduledID,@iOrderPlanID,@ScheduledDate,@DeliveredCnt,@iPauseDays,@NewDate)

update dbo.aDeliverySchedule
set ScheduledDate=@NewDate

FETCH NEXT FROM OrderPlanPauseCursor INTO @iScheduledID,@iOrderPlanID,@ScheduledDate,@DeliveredCnt
END
CLOSE OrderPlanPauseCursor
DEALLOCATE OrderPlanPauseCursor

[Limpire]

Open OrderPlanPauseCursor
FETCH NEXT FROM OrderPlanPauseCursor INTO @iScheduledID,@iOrderPlanID,@ScheduledDate,@DeliveredCnt
WHILE (@@FETCH_STATUS=0)
BEGIN

if @DeliveredCnt=0
Set @NewDate=DATEADD(dd,@iPauseDays,@ScheduledDate)
else
Set @NewDate=@ScheduledDate

INSERT INTO @OrderPlanPauseTable VALUES(@iScheduledID,@iOrderPlanID,@ScheduledDate,@DeliveredCnt,@iPauseDays,@NewDate)

update dbo.aDeliverySchedule
set ScheduledDate=@NewDate where current of OrderPlanPauseCursor

FETCH NEXT FROM OrderPlanPauseCursor INTO @iScheduledID,@iOrderPlanID,@ScheduledDate,@DeliveredCnt
END
CLOSE OrderPlanPauseCursor
DEALLOCATE OrderPlanPauseCursor