RE: Insert Table From Procedure OR Return Proc Result Set In UDF Table???

First idea that comes to mind is to customize your procedure into a UDTF.
Then you can use it like any other table (i.e. join it to another table).

I remember reading articles by Kent Milligan as well as Scott Klement
outlining how to do create a UDTF.

Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i5/OS and OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: Insert Table From Procedure OR Return Proc Result Set In UDF
Table???

I have a procedure that encapsulates a lot of logic and returns about 30
columns. Of which, I only need about 6 columns and I want to join the
resulset with other tables.

Is there a way for me to populate a session table from a CALL statement?
OR
Is there a way to call the procedure within a table valued UDF? If so, I
could only SELECT the columns I need.
OR
Is there some other way I haven't mentioned.

I'm open to all suggestions. I am in a time crunch.

Thanks in advance.

Ryan