how do i get the sum of the qty item for a particular item. For example I am trying to get a total for the amount cancelled on a particular item. So say if they order 50 and they cancel 49. I want to get 49 back as a sum for each item?????? going into a temp table???



UPDATE wd
set wd.qty_cancelled = l.qty
from #workingdata wd
INNER join lala l
ON wd.item= l.item
WHERE l.status = 'cancelled'