Below is the code using the restructured WHERE clause you posted. In testing I saw no noticable difference; 8-10 seconds....

Thanks Jeff, I tried the restructured WHERE clause, and there is no noticable difference in the time. Removing the DISTINCT keyword still causes it to return duplicates.

It seems that...

Well that little recommendation is worth a million bucks! Appears to be as fast as running the SELECT statement. Thanks:)

I guess I hadn't thought of that. I actually try to...

First I would like to thank you all for your replies. It took me a bit to digest all of the information, and read the articles on Parameter Sniffing.

After...