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 |
|
Mopani
Yak Posting Veteran
55 Posts |
 Posted - 2009-07-14 : 17:20:23
|
| I have two stored procedures1. imports text into a temp table2. compares the temp table to data table and updates or inserts.I have to manually run the first procedure, then manually run the second procedure.Is it possible to call the second procedure from the first?I will always run the second procedure, if the first one has been run. |
|
|
Mopani
Yak Posting Veteran
55 Posts |
Posted - 2009-07-14 : 17:31:03
|
is it as simple as EXEC store_procedure_name at the end of my first stored procedure? |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-14 : 23:51:26
|
| yes |
|
|
|
|
|
|
Call a sproc from another sproc ?