Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    7

    Post Unanswered: Processing the resultset of another proc from a proc

    Is it possible to retrieve the resultset of a stored procedure from another procedure in sql server 2000.
    Basically I am calling proc2 from the inside of proc1.
    proc2 returns 2 resultsets. I want to process these two resultsets
    from within proc1.

    If its possible , please provide sample code.

    thanks in advance,
    Alok.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Yes, with temporary tables for instance. But it will be easier if you can convert proc2 to two UDF table functions. Your code will be much clearer and simpler to maintain.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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