You are correct.  That fixed the problem...

I believe if you changed your cursor to LOCAL FAST_FORWARD (as in standard in SQL Server unless you explicitly need something else) then the...

• This reply was modified 3 years, 10 months ago by as400.
• This reply was modified 3 years, 10 months ago by as400.

This doesn't explain why the two execution plans are different.

I understand that I could make the perfect index to make this query work but that isn't the question.

The question is...

I understand that null cannot equal null.   If you look at my query that is why there is an or statement of (@x is null and @tempX is null).

Each...