title: I have temporary table which stores delete statement, I need to create a stored procedure during runtime which contain these delete statement
body: <p>temporary table data:</p>
  
  <pre><code>Delete from RISKASSESSMENTRULEOVERRIDE
  where RISKASSESSMENTRULEOVERRIDE.ApplicationNumber=@ApplicationNumber;  
  
  Delete from NONPANELMORTGAGEPRODUCT
  where NONPANELMORTGAGEPRODUCT.ApplicationNumber=@ApplicationNumber; 
  </code></pre>
  
  <p>and so on...</p>
  
  <p>I need to create a stored procedure which stores these delete statement inside that stored proc, so as when I get multiple values of  <code>@ApplicationNumber</code>, I don't need to iterate over each row, I can just have my query plan saved, as it may increase performance.</p>
  
  <p>I am not sure is it possible?</p>