I am new to triggers and need help on the following:

I have a hourly table that inserts new rows every hour but I need to either Insert or Update the daily table with the sum of the reading from the hourly table. If a row exist in the daily table with the date of the hourly table, then I need to update this row but if it doesn't exist, I need to insert this row.

Thanks for any suggestions...

Alan

What DBMS? Sounds like you should be using a materialized view (snapshot).

Thanks for replying, I have since moved this thread to the Microsoft SQL Server forum after posting to wrong forum. The DBMS is SQL2000

Thanks...
Alan