Professional Web Applications Themes

stored procedure and resultset - Microsoft SQL / MS SQL Server

How can I catch a resultset (in T-SQL) that returns from a stored procedure? A local variable with the datatype 'table' doesnt solve the problem, because declare tab table(table definition ...) insert into tab exec master..xp_msver will throw the errormessage 'EXECUTE cannot be used as a source when inserting into a table variable.' Any ideas? Thanks!...

  1. #1

    Default stored procedure and resultset

    How can I catch a resultset (in T-SQL) that returns from a
    stored procedure? A local variable with the
    datatype 'table' doesnt solve the problem, because

    declare tab table(table definition ...)

    insert into tab exec master..xp_msver

    will throw the errormessage 'EXECUTE cannot be used as a
    source when inserting into a table variable.'

    Any ideas?
    Thanks!
    Frank Guest

  2. #2

    Default Re: stored procedure and resultset

    you can not use table variable for following statements. you will have to
    use temporary table to do that.
    INSERT INTO table_variable EXEC stored_procedure

    --
    -Vishal

    "Frank C." <com> wrote in message
    news:023201c34a29$2900f8f0$gbl... 


    Vishal Guest

  3. #3

    Default Re: stored procedure and resultset

    You will need to use a #temp table, not a table variable. If you really
    need to use a table variable, you could do two selects, e.g.

    INSERT #temp EXEC proc
    INSERT tab SELECT * FROM #temp

    But yuck, why bother...



    "Frank C." <com> wrote in message
    news:023201c34a29$2900f8f0$gbl... 


    Aaron Guest

Similar Threads

  1. Caching a resultset from a stored procedure
    By zax_srb in forum Coldfusion Database Access
    Replies: 0
    Last Post: January 26th, 03:15 PM
  2. Stored procedure from stored procedure
    By Red Valsen in forum Informix
    Replies: 3
    Last Post: October 2nd, 02:22 PM
  3. Procedure wrapper needs 2nd Resultset?
    By Jonathan Beam in forum ASP
    Replies: 1
    Last Post: September 27th, 03:31 AM
  4. Replies: 5
    Last Post: July 25th, 05:51 PM
  5. Stored Procedure not returning the wanted resultset
    By Henning Kongsgaard in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 4th, 08:01 AM

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