ricardo_chicas (6/3/2013)
if I remove field 2 from the equation it will work just fineAny ideas?
An actual plan from the whole original query with "field 2" commented out as you describe will help immensely.
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