What I'm trying to do seems simple and as such I'm sure there is a real simple way to do this.
This is the query I have at the moment.
SELECT TOP 1 value, time
WHERE tag = 'sinusoid'
AND time <= '27/05/2009 15:05:06' ORDER BY time DESC
What I'm trying to achieve is selecting the value of sinusoid immediately before the time specified. The query above was working on the development environment but then stopped working. The error is "Event collection exceeded the maximum allowed". Looking at the query this makes sense as it will be returning loads of data.
What would be the recommended way to achieve this?