By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,272 Members | 1,403 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,272 IT Pros & Developers. It's quick & easy.

Multiple select statements in a single stored procedure.

P: n/a
I have coded multiple select statements in a single stored procedure, and
when I execute this procedure on SQL Server Management Express, I correctly
get multiple result sets. But, if I try to add a new Data Source to to my VB
2005 project, and point to this stored procedure, the data source wizard only
sees the 'first' select statement. Is there a way to load multiple tables in
a DataSet from a single stored procedure with multiple select statements?
TIA,
--
Terry
Jul 6 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Terry,

The first already gives your answer

http://groups.google.com/group/micro...8d87927915d6fe

Cor

"Terry" <Te***@nospam.nospamschreef in bericht
news:33**********************************@microsof t.com...
>I have coded multiple select statements in a single stored procedure, and
when I execute this procedure on SQL Server Management Express, I
correctly
get multiple result sets. But, if I try to add a new Data Source to to my
VB
2005 project, and point to this stored procedure, the data source wizard
only
sees the 'first' select statement. Is there a way to load multiple tables
in
a DataSet from a single stored procedure with multiple select statements?
TIA,
--
Terry

Jul 6 '07 #2

P: n/a
Hi Cor,
Thank you for yopur responce, but, the link you sent me to is in fact
wrong! At least as far as VS2005 is concerned. Under VS2003, when you drag
a stored procedure on the the form and generate a dataset, you get a table
for each select statement. Under VS2005 you only get a table for the first
select statement. Is this change in behavior intentional? If so, I wonder
why. It sounds like a bug to me.
--
Terry
"Cor Ligthert [MVP]" wrote:
Terry,

The first already gives your answer

http://groups.google.com/group/micro...8d87927915d6fe

Cor

"Terry" <Te***@nospam.nospamschreef in bericht
news:33**********************************@microsof t.com...
I have coded multiple select statements in a single stored procedure, and
when I execute this procedure on SQL Server Management Express, I
correctly
get multiple result sets. But, if I try to add a new Data Source to to my
VB
2005 project, and point to this stored procedure, the data source wizard
only
sees the 'first' select statement. Is there a way to load multiple tables
in
a DataSet from a single stored procedure with multiple select statements?
TIA,
--
Terry


Jul 9 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.