Post reply

Execute a stored procedure inside a SELECT

  • October 1, 2003 at 6:52 am

    #160876

    How would I run a stored procedure within a SELECT statement?

    Is it possible to do this without creating a string first and executing that?

    eg. SELECT col1, col3, (EXEC sp_DoStuff) FROM Table

  • October 1, 2003 at 7:29 am

    #476551

    You might look at UDF's for this kind of functionality, of course they have their limits as well.

    HTH

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • October 2, 2003 at 7:32 am

    #476751

    You can't...use Tabel valued Functions! Their Great <Tony the Tiger impression>!

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

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