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...
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...