Professional Web Applications Themes

Getting Rows from Stored Procedures - Microsoft SQL / MS SQL Server

You can do this with #table but not table (this is one of the limitations of table variables). CREATE TABLE #table ( Column1 BIGINT, Column2 VARCHAR(50) -- not a zip code, is it? ) INSERT #table EXEC MyStoredProcedure SELECT * FROM #table DROP TABLE #table Also see http://www.algonet.se/~sommar/share_data.html "Osvaldo" <com.ar> wrote in message news:#phx.gbl... I want to do something like this: DECLARE Table(FirstField bigint,SecondField varchar(50)) SET Table = EXEC MyStoredProcedure /* OR..... */ SELECT * FROM MyStoredProcedure How can i do this? (I mean, to get the row of a SP Within another SP.) -- ******************************* Osvaldo Bisignano Buenos Aires, ...

  1. #1

    Default Re: Getting Rows from Stored Procedures

    You can do this with #table but not table (this is one of the limitations
    of table variables).



    CREATE TABLE #table
    (
    Column1 BIGINT,
    Column2 VARCHAR(50) -- not a zip code, is it?
    )

    INSERT #table EXEC MyStoredProcedure

    SELECT * FROM #table

    DROP TABLE #table




    Also see http://www.algonet.se/~sommar/share_data.html





    "Osvaldo" <com.ar> wrote in message
    news:#phx.gbl...
    I want to do something like this:

    DECLARE Table(FirstField bigint,SecondField varchar(50))

    SET Table = EXEC MyStoredProcedure

    /* OR..... */

    SELECT * FROM MyStoredProcedure

    How can i do this?

    (I mean, to get the row of a SP Within another SP.)





    --

    *******************************
    Osvaldo Bisignano
    Buenos Aires, Argentina
    ICQ#96485948






    Aaron Guest

  2. #2

    Default Re: Getting Rows from Stored Procedures


    Thanks very much. Never as simple as it should.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Osvaldo Guest

  3. #3

    Default Re: Getting Rows from Stored Procedures

    maybe you can rewrite your SP as an UDF (if you use SQL 2000) and then you
    can use SELECT * FROM udf_name() syntax

    "Osvaldo" <com.ar> wrote in message
    news:#phx.gbl...
    I want to do something like this:

    DECLARE Table(FirstField bigint,SecondField varchar(50))

    SET Table = EXEC MyStoredProcedure

    /* OR..... */

    SELECT * FROM MyStoredProcedure

    How can i do this?

    (I mean, to get the row of a SP Within another SP.)





    --

    *******************************
    Osvaldo Bisignano
    Buenos Aires, Argentina
    ICQ#96485948






    Nagy Guest

Similar Threads

  1. Stored Procedures
    By Anthony M. Davis in forum Coldfusion - Advanced Techniques
    Replies: 28
    Last Post: February 9th, 03:17 PM
  2. dt_ Stored Procedures
    By chopper in forum ASP Database
    Replies: 2
    Last Post: July 20th, 04:06 PM
  3. Stored Procedures and 4GL
    By Ahmer Sajjad in forum Informix
    Replies: 1
    Last Post: September 9th, 01:23 PM
  4. Stored Procedures
    By Vladi in forum Microsoft SQL / MS SQL Server
    Replies: 9
    Last Post: August 13th, 01:52 PM
  5. SQL-DMO and stored procedures
    By in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 24th, 02:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139