I did not consider to normalize and properly index your tblResults table. I'll have to look up tomorrow on how to do that. I'll also submit the full query tomorrow as well.
Thanks so much for your help. Until recently my experience with SQL server has been writing simple insert or update procedures to work with forms from .Net. Nothing to this magnitude.
I'm definitely excited. While 7 seconds sounds like a long time for this. We were looking at hours for this stuff to run before.