Viewing 3 posts - 1 through 3 (of 3 total)
Better yet......
1) How many rows are you dealing with
2) What indexes, if any, exist on the source data
3) Are you able to recommend the creation of any indexes on the...
August 24, 2006 at 9:11 am
#656617
Just out of curiousity, how many rows are you dealing with?
Sven
August 24, 2006 at 9:09 am
#656615
Mayhaps I am not understanding your requirement but I would think that once the WeekTargets are updated, to update the WeekCumalative would something like this.
update A
set WeekCumulative = (select sum(weekTargets)...
July 24, 2006 at 2:36 pm
#651192