Multiple Result sets from a sproc

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Multiple Result sets from a sproc

Author

Topic

X002548
Not Just a Number

15586 Posts

Posted - 2007-10-12 : 13:59:09

I have a reuest the is going to produce 6 result sets from a single

The page is a mess, so I don't know what value this is going to be

BUT Does any do this? Is there going to be any performance issues?

Has anyone else done this?

I usually find a way to avoid this, but I can't this time

I would imagine it would be better than 6 sproc calls

Whatdya think?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-12 : 14:07:10

I've got an application that does this. I'd prefer one result set per object, but they insist having multiples in some cases. .NET handles it very easy as you can put it into a dataset which has multiple data tables (one data table per result set).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-12 : 14:19:05

multiple result sets are a breeze as tara said.
you can even get them all in a SqlDataReader. you just need to use NextResult method.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

X002548
Not Just a Number

15586 Posts

Posted - 2007-10-12 : 14:21:32

Tanks Tara

Go Chargers!

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

X002548
Not Just a Number

15586 Posts

Posted - 2007-10-12 : 14:23:05

quote:
Originally posted by spirit1

multiple result sets are a breeze as tara said.
you can even get them all in a SqlDataReader. you just need to use NextResult method.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

Well I won't have too...ugh...presentation

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-12 : 14:33:44

quote:
Originally posted by X002548

Go Chargers!

Bring Schottenheimer back!

Let's just hope we smoke the Raiders on Sunday like we always do.

Go Bolts!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources