It does...

I tried the following two items and the response went from 2+ minutes to less than a second:

1) Extract the Codes values to a temp table indexed on the code...

I am going to try 2 things:

1) Extract the Codes values to a temp table indexed on the code value. For a given client there shouldn't be more than 100...

Jack,

Thanks for getting back to me. As for your comments/recommendations

1. You are using functions on columns in the where clause which means they are not SARGable so you are...