An INSERT EXEC statement cannot be nested.

• Yuvraj Powar

  Old Hand

  Points: 322

  More actions

  October 21, 2004 at 6:18 am

  #60119

   When I try to excecute Sp having nested sp calls  I got following error .

  is there any solution to this problem.

  Thanks in  Advance .

   

  Yuvraj

• Jeff Moden

  SSC Guru

  Points: 1004589

  More actions

  October 21, 2004 at 6:49 am

  #527444

  You forgot to post the error...

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• noeld

  SSC Guru

  Points: 96590

  More actions

  October 22, 2004 at 7:30 am

  #527643

  Yes You can't nest a sp that uses the insert exec construct. Try to use those at the Top level instead.

  HTH

    

  
  * Noel