sql_er (8/25/2008)
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.
I agree with what Kevin said... the "regulars" won't think it strange at all,. Heh... it's what they usually recommend!
--Jeff Moden
Change is inevitable... Change for the better is not.