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?