title: Calling stored procedure from another procedure with where clause
body: <p>I have a table <code>tblemployee</code> with this sample data:</p>
  
  <pre><code>srno name      Lastname
  ------------------------
  1    Ibrahim   shaikh
  2    ibrahim   mohammed
  3    ibrahim   khan
  4    paul      haymen
  </code></pre>
  
  <p>And I have a stored procedure <code>SPGetEmp</code>. When I execute the procedure like this:</p>
  
  <pre><code>SPGetEmp 'ibrahim',''
  </code></pre>
  
  <p>it is returning this result data:</p>
  
  <pre><code>srno name      Lastname
  ------------------------
  1    Ibrahim   shaikh
  2    ibrahim   mohammed
  3    ibrahim   khan
  </code></pre>
  
  <p>Now I want to filter the data from another stored procedure, like now I want to filter the data with last name, for example <code>'shaikh'</code>.</p>
  
  <p>Result should be:</p>
  
  <pre><code>srno name      Lastname
  -----------------------
  1    Ibrahim   shaikh
  </code></pre>
  
  <p>What should I do?</p>