title: Calling one stored procedure within another stored procedure using variables from first stored procedure
body: <p>I have a stored procedure say <code>@Create_Dummy1</code> which is being passed a variable. This is declared as <code>@Dummy_Variable1</code> in this stored procedure. </p>
  
  <p>Next I need to call another stored procedure  <code>@Create_Dummy2</code> from <code>@Create_Dummy1</code>. I need to pass <code>@Dummy_Variable1</code> in the <code>exec</code> statement. </p>
  
  <p>But if I try to do this the string <code>@Dummy_Variable1</code> is only being passed instead of the value it holds.</p>