title: How to run store procedures simultaneously
body: <p>I'm doing a job to tuning some store procedures got situation like this:</p>
  
  <p>there is a procedure let's call it sp_summary it will do some prepare work first and then it will exec like 10 procedures in serial. basically it's :</p>
  
  <pre><code>   create procedure sp_summary(date datetime)
      as 
       Begin
        Declare @v1 varchar(10)
        .....
        .....
        exec sp_sub_1
        exec sp_sub_2
        ....
        exec sp_sub_10
        ....
        ....
      End
  </code></pre>
  
  <p>almost each of them will cost like 2 minutes and 20 for total, and all their doing is just create a temp talbe catch some data from source table and calculate some columns then insert into the target table.</p>
  
  <p>the question is:</p>
  
  <p>how to exec the 10 sub sps simultaneously to make the 20 minutes per day become like 2 or 5 mins per day. And since all 10 sub sps got same source table and same target table, how to do the Transaction Isolation to avoid create dirty data.</p>
  
  <p>P.S: Informatica or SSIS or other ETL tools are not an option. Any DBMS solution would be great</p>