I am trying to update a null column with a cummulative total (runtot). I have a SortOrderID on the table (sorts ASC by the column I need to set the cummulative on). In my results I just get the total with this query for each record. Variations either die because the joins or various syntax mistakes.

thanks.

Update a_temp_filterID123_PopulationSorted
SET runtot =
(
SELECT SUM(PaidAmount)
from a_temp_filterID123_PopulationSorted b
WHERE b.SortORderID <= SortOrderID
)