Hi,

I followed your instructions. The results are:

Original subquery gives: 69000

Proposed query containing cross apply: 69000,Int.nr.TXT: 69000

So the original query works fine as long at is not part as a nested query for the rest of the stored procedure.