on 10-31-2007 7:28 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Rick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.