It's possible. See
Re: Using result set Message #
644072>hi,how can i use the result of a store procedure to a select statement.
>is this posible or any alternative ?
>select a.*
>from ((store procedure here )) a
>
>?
>Ive try this using functions but function has many limitations.
>tnx
--sb--