Post reply

Stored Procedure Output As Field Value

  • October 10, 2003 at 5:26 pm

    #176797

    In SQL Server 7.0, is it possible to use the results of a stored procedure as a query field value if the stored procedure has an OUTPUT value? Can somone provide an example if it is possible?

  • October 13, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • October 14, 2003 at 5:18 am

    #478114

    Do you mean to 'embed' the procedure into the query as one of the result fields? That can't be done, AFAIK, but if you start the procedure before you start the query and store the result somewhere, well, that's another thing and should be no problem.

    In SQL2000 there are user defined functions, which can be used directly in a query - but even there, if I'm not confused by something, you can't launch sp from inside a query and use its result as one of the query output fields.

Viewing 3 posts - 1 through 2 (of 2 total)

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