Kevin,

> I have a procedure that is using an index in one select statement, but

not

> the another identical one....

Based on my visual review, there is no obvious reason for the difference
-- so you're not going crazy. ;-)

But let me point out, that you are using the same table aliases for the
2 statements -- I generally only use an alias once in an SP (just my own
little 'standard').

What happens if you change the aliases in the 2nd statement?


Sean