I seem to get the following error on the line with setamount - 978.

Server: Msg 170, Level 15, State 1, Line 13
Line 13: Incorrect syntax near '='.

any ideas?

update InvestmentSumma ry
Set UnitsOut = -17849.26409
where InvestmentSumma ryUID = 140401

Set AmountOut = 978.63
where InvestmentSumma ryUID = 141607

Set AmountOut = 40773.07
where InvestmentSumma ryUID...