|I would like to know if this is possible. Then if it is possible how would you go about solving it.|
Currently we have a database logging an event every few seconds. We would like this rate to countinue because it is needed in other business areas, but for our business area we do not need data logged this often.
Instead we would like a SQL statement that would pull a data entry every minute. So for example if the time stamps fall within the range below we would like only one value recorded per the below series.
The SQL statement would need to contain this logic. A script may be better? As stated above I do not know if this is possible or how one would go about doing this.
Let me know if you have any more questions or thoughts on this matter.