I have an engineering system writing alarms to a SQL server 2000 table. I would like to process the table at night and store the results in a new table.
It will look at all alarms in a 24 hour period and for each distinct record occurrence count the frequency for the alarm for that 24 hour period and for the preceding period of
8-90 days. Store the results in a table. (I’m looking for chronic alarms)
Resulting in something like this for rows of the stored table:
View Complete Post