>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.
>
>
>
>>Jim,
>>
>>If your earlier selects all do insert into #tables there won't be any result to come back. You can create a temporary SP, call it and drop it. But overall the best thing to do is write a bonafide SP that SQL can create a decent query plan for and call it.
>>
>>>But I think there's gotta be a way directly, as opposed to a SP.
>>>
>>>Do you think SP is the only way?
Check Boris' reply. You could use SP,UDF,temp SP alternatively, provided you have right to do so.
Cetin