Sum up a column and then update a temp table with results

[Joell]

I am using SQL 2000. I want to sum up a column and then add that to a newly created table.

How do I do this in SQL Server ? Below is what I am getting the error on:

update #temptable
Set Aug_total = Sum(hist.amount)
Select sum(hist.amount)
from cust inner join hist on
cust.c_id = hist.c_id
where blah blah blah....

The error SQL returns is:
An Aggregate may not appear in the Set list of an Update statement.

How do I get sum totals to put into my temp table?

[deric]

Is this what you mean?

update #temptable
Set Aug_total = (
Select sum(hist.amount)
from cust inner join hist on 
cust.c_id = hist.c_id
where blah blah blah....)

[jobspider1000]

An aggregate may not appear in the set list of an UPDATE
statement.

I also was struggling with this error

for some days finally i got the solution

Which all i put into my blog


http://sqlerrormessages.blogspot.com...ar-in-set.html