Dear mister.magoo,

that's impressing! your solution is absolutly useful for me, thanks a lot!

I tried something like this:

1. "unpivot" start- and endtime into dt-, and type column

2. compare current and...

Eugene, I believe you 🙂

altough it is contradict to what I've learned about logical query processing.

and yes, the use of a temporary table is probably the only solution to...

yes, it seems that the conversation to datetime is performed before the WHERE filter.

maybe because of parallel processing and the large size of the table A (~300 MB)....this is new...