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 2012 Forums
 Transact-SQL (2012)
 Getting values from a stored proc

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -