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