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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-29 : 09:39:03
|
chun writes "I have a stored procedure returning a recordset and I would like to use some of the fields in there in another stored procedure... I think I need to use exec(sp_mystoredproc), but how do I grab data from that exec command and put it into a variable, let's say @myvar?
I tried this and it doesn't work
CREATE PROCEDURE SP_test
AS
@myVar = exec SP_otherStoredProc
insert into test values (@myVar)
GO
you guys are great, thanks very much..." |
|
|
|
|
|
stored procedure within stored procedure