How would you explain the fact I got 2 Index seeks with your test code and my addition of populating tables?
>No, no matter if PRIMARY KEY index is CLUSTERED or not in both cases I have INDEX SEEK.
>Thanks again Walter.
If it's not broken, fix it until it is.
My Blog