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 - 2004-08-25 : 18:57:48
|
| pratik writes "Hi Sql Team,I have two Stored Procedures 1. StoredProc_One - This returns multiple tables. Syntex: Create Procedure StoredProc_One As Begin Select * from Table1 Select * from Table2 Select * from Table3 End 2. StoredProc_Two In this Stored Proc, I want to call "StoredProc_One" and want to modify Table1, Table2 and Table3. Is it possible ? If yes, How to access Table1, Table2 etc in StoredProc_Two ? I would be really thankful your help to me.RegardsPratik" |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-25 : 19:28:02
|
| You can't modify tables in the first SP because it's only using a SELECT. You can modify the tables independently, though. Probably best to explain exactly what you're trying to do. |
 |
|
|
|
|
|
Nested Stored Procedure