Skip to Content
avatar image
Former Member

Multiple record sets returned from stored proceedure

I have a stored procedure in SQL2005 that returns multiple record sets. When I call the procedure from xMII using a fixedquery, I only get the first record set returned. Her is the syntax I am using:

EXECUTE [dbo].[GetSettings] 
   0
  ,0

Any help is appreciated.

Regards,

Christian

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 31, 2007 at 07:56 PM

    Can't do it with xMII, Christian. If the recordsets are the same "shape", you'll need to union them in the stored proc and output a single resultset.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2007 at 07:57 PM

    Thanks Rick

    Add comment
    10|10000 characters needed characters exceeded