>>:) No, this one is not about the proximity search :) It is mostly about CROSS APPLY technique.
>
>Yes, but, I have a lot of work to do to complete all this, standardize that in the framework, documentation, etc., so this CROSS APPLY technique is way too complicated for me right now. When I'll have time, I'll take a look at it.

I was wrong with that link. The one that shows technique is this one

http://bradsruminations.blogspot.com/2009/07/cool-cross-apply-tricks-part-2.html

Anyway, I need to get back to work as well.