title: Run stored procedure passing a parameter from Batch file
body: <p>I have the below in a batch file and can not seem to get the <code>%1</code> value to pass to the stored procedure.  I have tried many combinations and searches without success.  Can someone tell me how to format the command to pass that value to the stored procedure.  I know the value is making it there because of the echo.  The value is like such <code>0055731</code>.  thanks for any help.</p>
  
  <pre><code>echo %1
  pause   
  sqlcmd -S Esserver\rsssql -d RSSIntegration -Q "exec sp_ImportSageOrders " &amp; %1
  </code></pre>