Why not just use a UNION in your stored procedure and just get a single
result set back?
HTH,
Matt
-Original Message-
From: adonis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 11:26 AM
To: [EMAIL PROTECTED]
I have created a stored procedure in Sql Server which uses a cursor
I have created a stored procedure in Sql Server which uses a cursor and
returns multiple identical(schemawise) resultset. When this stored
procedure is used to populate a dataset, naturally multiple datatables are
created. I need to merge the data avaiable in these multiple tables of the
dataset