update oj
set oj.priority = oj.priority + newoj.raise
from OptimizationJob oj
	inner join (
select OptimizationJobID,  ROW_NUMBER() over(order by SUM(sod.quantity) * AVG(sod.unitprice) asc, priority) as raise
From OptimizationJob oj
	inner join SalesOrderDetail sod on (sod.productid= oj.ProductID and sod.Status<580)
where Priority > 30
and IsCompleted = 0
and UserID is null
group by OptimizationJobID,oj.priority
) newoj on (newoj.OptimizationJobID = oj.OptimizationJobID)