Oh man did you get me... brilliant! I certainly believed it as I was reading it, and you almost had me convinced that it might be a good idea....

Thanks GSquared! I appreciate you already taking the time to go through the first SQL and based on the feedback I've seen, I am going to use temp tables...

There are about 110,000 records in the table right now; I don't know how to tell about index fragmentation.

Jeff Moden - Oops, sorry, I thought you were being frivolous before; was kind of hard to tell what you meant. Thanks! I will check that out.

GSquared -...

I am trying to be very conscious of the fact that people who are donating their time to the forums would prefer to answer simple questions rather than lengthy ones....

I assumed (possibly incorrectly) that people would be more likely to answer a general question rather than puzzling through the details of my specific code. Is it really true...