Executing 5 procedures in one procedure

• koti.raavi

  SSCrazy

  Points: 2756

  More actions

  December 17, 2014 at 4:02 am

  #147187

  Hi All,

  Can any one help me out how to execute 5 procedures in one procedure one by one ( one after another) ...Do we have to use go after each SP?..thanks

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  December 17, 2014 at 4:16 am

  #1765116

  koti.raavi (12/17/2014)

  ---

  Hi All,

  Can any one help me out how to execute 5 procedures in one procedure one by one ( one after another) ...Do we have to use go after each SP?..thanks

  Do not use Go.

  Use

  exec schema.ProcName1

  exec schema.ProcName2

  etc etc

  ---