>Jim,
>
>PMFJI, Sql Server allows to use result set returned by one query (called derived table) as a source of another. You could redisign your sequence of 3-8 queries into one using derived tables and joins. Even using sproc's you should do that to make queries more effficient.
>

Correct... I think I mentioned that. But, it is hard to imagine the power of derived tables until you use them.

BOb