Subject Re: Stored Procedure as a Function?
Author apribek
Thanks a lot Martijn, this will do perfectly for me!

--- In, "Martijn Tonies"
<m.tonies@u...> wrote:
> Hi Adam,
> > Is it possible to use Stored Procedures as (UD) Functions, ie.
> > declared a procedure XY is there a way to use the "select col1, XY
> > (col2) from foo" or similar syntax? Or any ideas to achieve this?
> > know that I could do it with a select procedure that would return
> > same thing using an execute procedure in a select loop, but I am
> > looking for something that looks more like a selection).
> Pretty much the only thing you can do is:
> select col1, (select outputparam from xy(col2) )
> from foo
> With regards,
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird & MS
SQL Server.
> Upscene Productions