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 |
|
Mortifier
Starting Member
11 Posts |
 Posted - 2003-07-20 : 04:22:09
|
| Hi,I have a stored procedure that returns a recordset. I wanted to execute this stored procedure in another stored procedure so that I can use one field from the recordset result. What is the best way of doing that?Thanks,Kevin |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-07-20 : 04:27:57
|
| HiOne way of doing this is capturing the result of a stored proc in a temp table.Something like this :Create Table #results(id int,FirstName varchar(50),LastName varchar(50))INSERT INTO #Results (id, FirstName, LastName)Exec MyStoredProcThat will fill your temp table with the results of "MyStoredProc"Damian |
 |
|
|
|
|
|
Using recordset in a stored procedure