Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003

    Unanswered: Accessing Second Record Set

    hello all,

    i had two stored procedures,where the 1st SP is calling 2nd SP(which returns 2 record sets).
    how can i access the second recordset from the 1st SP

    it would a great help if anyone help me out!!

    thanx in advance,

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    WHY? I mean, you could rig up some hackneyed process that loads the data into a temp table and parses out the recordset you want, or whatever, but there is just never a good reason for building applications this way. One stored procedure should return one recordset. One function should return one recordset.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I agree with Blindman 100% on this issue. Stored procedures can return more than one result set. This is to allow for nested procedures that each return their own result sets (like sp_help does). I can't think of any reason that a procedure should be designed to intentionally return more than one result set, other than as a user convenience "wrapper" for a group of other procedures.


Posting Permissions

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