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 |
|
vivo
Starting Member
24 Posts |
 Posted - 2010-03-09 : 01:55:51
|
| Can someone help me how to execute another proc once for each query result ?select records from ... where...exec existing procedure passing param values from select where ..If success , commit If not, rollback |
|
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
Posted - 2010-03-09 : 02:02:12
|
quote:
Originally posted by vivo
Can someone help me how to execute another proc once for each query result ?select records from ... where...exec existing procedure passing param values from select where ..If success , commit If not, rollback
Could you please refer Mr.Madhi Bloghttp://beyondrelational.com/blogs/madhivanan/archive/2007/11/24/select-columns-from-exec-procedure-name-is-this-possible.aspx |
 |
|
|
|
|
|
Call another proc from current proc