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.
| Author |
Topic |
|
mauler05
Starting Member
17 Posts |
 Posted - 2007-10-02 : 12:01:08
|
| Hi,I have question for u guys........If my stored procedure returns multiple resultset.....fro example different select statement in a procedure..........then how can i consume the result in T SQL For instance i need to hold value of a column1 of resultset1 in a variable if it matches certain condition...Any help in this regard will be highly appreciated...Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-02 : 13:09:31
|
| you can't in t-sqlin your .net client app you can use datasets for this._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-03 : 03:14:16
|
| or in VB, use NextResultset method of a RecordsetMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Multiple Resultset