i want to sum up the values during the update process but error raises
Msg 157, Level 15, State 1, Line 21
An aggregate may not appear in the set list of an UPDATE statement.
Msg 157, Level 15, State 1, Line 29
any help will be appreciated
You need a SELECT befor the SUM(...).
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?