Continue loop after stored procedure done


  • foreach(....)


    //My stored Procedure


    My stored procedure takes several times to done but sometimes foreach doesn't allow it done and takes step forward. What should I do?

    Sunday, March 23, 2014 11:20 AM

All replies

  • Post foreach code and stored procedure code for assistance.

    Describe precisely what is the issue.


    Kalman Toth Database & OLAP Architect SELECT Video Tutorials 4 Hours
    New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012

    Sunday, March 23, 2014 11:51 AM
  • Debug the code. Are you using any Asynchronous operation or threading in your application ?

    Regards, RSingh

    Sunday, March 23, 2014 12:01 PM
  • Do you know that FOREACH is not part of SQL?  That // is not part of SQL? 

    How do you expect anyone to answer this question with the code and data you gave us? 

    Rudeness and ignorance are a bad way to get help on a forum. Want to try again, with Netiquette and information?  

    --CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL

    Monday, March 24, 2014 4:32 AM