[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?

Expand|Select|Wrap|Line Numbers

1. update #temptable
2. Set Aug_total = (
3. Select sum(hist.amount)
4. from cust inner join hist on 
5. cust.c_id = hist.c_id
6. where blah blah blah....)