Hi folks,
I have to get all Bad-Values and the next Good-Value to each of them (in the last 9 month) for a couple of Tags (about 800-900).
Getting all Bad-Values is no problem but getting the corresponding Good-Values isn´t. My try is to query the next event for each Bad-Value. There is a massive performance problem in my guess. I have about 14.000 Bad-Values for each Tag. This means 14.000 Select-Statements for each Tag.
Is there a single statement where I can query Bad-Events and the next event?
I would be glad for every hint.
fesl
