Post reply

Accessing a stored procedure in a SELECT statement.

  • August 31, 2005 at 2:48 pm

    #91010

    I've written a stored procedure which returns a set of records. Is it possible to wrap this stored procedure in a view so that it can appear in the FROM clause of a SELECT statement?

  • August 31, 2005 at 3:05 pm

    #586663

    No, if you need the select to have parameters, then transform the proc into a table function, otherwhise just make it a view.

  • September 1, 2005 at 7:04 am

    #586801

    Thats all well and good, but what if the returned table's definition depends on the arguments to the function? (i.e. I only know the set of fields at execution time).

  • September 1, 2005 at 8:52 am

    #586851

    Can we see the code of the sp please?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply