Triggers

[Pete Elliott]

I am trying to develop a trigger within a table (table 1) which is being updated every 5 mins from an OPC connection.

I wish to insert data from table 1 into another table (table 2) however I wish to average the values over a 24 hour period therefore allowing me to reduce data within stored within table 2 to form am archive for the data for a period of > 12 months.

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

The columns within my table are

ID, Value, Timestamp, Description

Any help would be much appreciated