[thelist] SQL 2000 update statement

[rudy]

what's the query to create each day's data in the summary table? do you
need to keep the detail rows in the summary table?

if not, try

  insert into summary (custname, ordertotal)
    select custname, sum(orderamt)
  from orders
     group by custname

rudy