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 |
|
mikerea
Starting Member
1 Post |
 Posted - 2015-03-05 : 10:53:37
|
| I have a stored proc that gathers a whole bunch of data, places it into various temp tables, then shows the data and deletes the temp tables.So basically what I get is a whole bunch of table views each with 1 record and all containing data.Is there any way that I can get any of the data that it shows into a variable for output?I know how to do it if I have a stored proc that gets or calculates 1 piece of data, but no idea given that it is returning lots of data. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-05 : 12:42:37
|
| Show us a data example of what you mean as I can't picture it.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Getting values from a stored proc