title: SQL procedure performance question
body: <p>Which of these have a better effective performance when used from ASP.NET</p>
  
  <p>SP1:</p>
  
  <p>Returns 100 params</p>
  
  <p>SP2:</p>
  
  <p>Selects 100 params from SP1 into a temp table by doing a EXEC SP1
  Selects 20 params from temp table</p>