Jim,
You can stack up multiple SQL commands inside a single SPT call. You should be careful because all these SQL statements can be interpretted as a single monolithic transaction on the server and there is a possibility that it may cause significant blocking issues. That would not be the case if you just did this as a SP which it really should be.
>It's a series of SQL SELECTs with no intermediate processing.
>
>It roughly goes as follows:
>
>- SELECT a subset of records with specific characteristics (has a UNION)
>- SELECT some records INNER JOINed on first above
>- 4 UNIONed SELECTs to get additional records of interest also INNER JOINed on first above
>- FULL JOIN of last 2 above, producing result set of interest. All other results ignored.
>
>It just seems to me that I should be able to do this using SPT, returning the single final cursor of interest.