I am not free to assume that I will be able to add/update stored procedures on client sites. This is not for an in-house system, but rather for one sold broadly.
I'm hoping to find that the "derived tables" or "temp tables" can be specified through SPT and that the final table of interest can be somehow designated as the single one to return.
It *may* be possible to make one huge SELECT statement, but I'd like to maintain some degree of readability, which is nicely afforded using multiple SELECTs. OK....I won't make any assumptions about your environment, though I am curious how you push out updates (table structure changes, and do you use a script, and what rights any scripts would have, etc.) Food for thought...
Kevin