Dhasian, Chris

Thanks for your kind support.

Dhasian,

The query is working fine and much better then before. Good Job. But adding a where clause results in increased scan counts on "person".

Chris,

The query works equally good even with where clause.

OLD

Table 'person'. Scan count 3, logical reads 9593

NEW

Table 'person'. Scan count 1, logical reads 4498