douglasbrown880 (4/14/2016)
Here you go.This is from a different app server and database, however the issue is the same
It's an estimated plan - can you post an actual plan?
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