---------- Original Message -----------
From: "vladman992000" <myles@...>

> SELECT * FROM PROCESSING_SP(
> SELECT ID FROM TABLE WHERE ID > 100);
>
> What is the correct syntax for doing this sort of thing in a stored
> procedure input argument set?
>
> Myles

------- End of Original Message -------

The way I do it is

select processing_sp.* from (select id from table where id > 100) input_tb left
join processing_sp(input_tb.id) on 1=1;

or

select processing_sp.* from table left join processing_sp(table.id) on 1=1 where
table.id > 100;

I'm not sure that's the *best* way, but it seems to work for me.

-Philip