sql_er (8/25/2008)
Thanks for all the suggestions.I was able to fix the problem without adding an index, but just re-writing the query.
It was strange how a very simple change in the query made it much faster.
Thanks again!
Heh... two way steet here. 😀 What was the "very simple change in the query" you made?
--Jeff Moden
Change is inevitable... Change for the better is not.