>>> WHERE END_TIME <= Time(Frac(Now()), 'hh:mm') <<
(I want to load from a database table all records from today (there is another filter for that) and up to the ReloadTime (I could alternatively place it in the preceding LOAD, but it would be more elegant to just not load any unwanted records from the database instead of dropping them afterwards.
Also, as the report is supposed to run every 10min, keeping the SQL_SELECT to the absolute minimum is crucial.
One more: I want to use WHERE-clauses to exclude two values: Like
>> WHERE Class <> "A" and Class <> "S" <<
That should be valid - but I know that there can be significant differences in performance, depending on how a query is formulated. Is there a better way to write this? - I cannot "turn it around" and filter for only the values I want, I don't know what those values are/ can be and there might be more going forward.