Chris,

Thanks alot! That is exactly what I needed. I had tried the CrossTab approach earlier, but forgot to include the MAX statement. Thanks for pointing me...

Hi Craig,

Thank you for your help! My problem turned out to be "HAVING ViewProperty >0", which turned out to a redundant step in my process since the RESULTS table...

Thanks for your help everyone! It appears that it is as good as it is going to get so I think that we are going to leave things as...

Searches against string values tend to be slower than those against numerical values and we are looking for ways to speed up searches against commonly used fields such as an...