Re: Triggers

[Peter Brawley]

> insert data from table 1 into another table (table 2)
> however I wish to average the values over a 24 hour period

Average values of what?

> therefore allowing me to reduce data within stored within table 2
> to form am archive for the data for a period of > 12 months.

Not nearly enough info for designing a Trigger ...

1 write out every step in the logic

2 translate the result of #1 into pseudocode

3 translate #2 into SQL

In order to help, we need to start with the result of step 1.

> Timestamps within my table presently are shown as YYYY-MMM-DD 00:00:000

Unless it just happens to be the case that all stored events occurred exactly at midnight, those are invalid timestamps.