GonnaCatchIT (6/16/2015)
Thanks Chris, I will check and build my query based on this , will provide you the results. Thank you
It's a long shot without the execution plan and table ddl.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden