Post reply

Can a select statement be used to parse the results of a stored procedure ?

  • March 10, 2012 at 6:12 am

    #269809

    Hi all,

    If I exec an sp, I see my results table in the query analyser. But could I do this (or something like this ?)

    select * from (

    exec getdata ) A

    I believe I CAN do this with a function, but perhaps not from an SP.

    All I think I can do is to load the results of the SP into a tmp table and then parse that...any advance on this ?

    Regards, Greg

  • March 10, 2012 at 6:25 am

    #1457470

    You might want to have a look at Erlands blog for several options.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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