title: "Stored Procedure has too many arguments specified" SQLServer
body: <p>I have built a stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE dbo.sp_orders_by_dates 
      @start_date datetime,
      @end_date datetime
  AS
      SELECT
        order_id, 
        orders.customer_id, 
        customers.name,
        shippers.name,
        shipped_date
      FROM orders 
      INNER JOIN customers ON orders.customer_id = customers.customer_id
      INNER JOIN shippers ON orders.shipper_id = shippers.shipper_id
      WHERE shipped_date BETWEEN @start_date AND @end_date
  </code></pre>
  
  <p>When I execute the procedure using:</p>
  
  <pre><code>EXECUTE sp_customer_city 'January 1, 2003', 'June 30, 2003'
  </code></pre>
  
  <p>I receive:</p>
  
  <pre><code>Msg 8144, Level 16, State 2, Procedure sp_customer_city, Line 0
  Procedure or function sp_customer_city has too many arguments specified.
  </code></pre>
  
  <p>Have I not properly specified that this procedure can take two arguments?</p>