very strange: run sp vs run t-sqls in sp one by one

• ColinChen

  SSC-Addicted

  Points: 414

  More actions

  August 2, 2010 at 9:56 pm

  #100290

  I had a SP having many t-sqls.In the sp, there were 2 temp tables to update,insert.

  And the sp was always hold on one update t-sql.It need 2 or 3 hours to complete the t-sql.

  And I run t-sqls in the sp one by one, it was very fast.

  C.G

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736254

  More actions

  August 3, 2010 at 7:41 am

  #1201521

  You'll have to provide more information for us to understand, and perhaps ask a question.