Hi Kevin,

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.

cheers

>Hi, Jim,
>
>At the risk of repetition - if you are able to use stored procedures (i.e. no database restrictions), you really should do so.
>
>You can use derived tables, or table variables/temp tables to produce the result sets that lead to your final result set.
>
>I haven't used SPT in a little while....but I would *think* (but not positive) that the only way to get back one result set via SPT, is if you can pull off one long statement used derived tables, or subqueries, etc to get the results you want.
>
>
>Kevin