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