title: SQL Incorrect syntax when trying to CREATE PROCEDURE
body: <p>I keep getting an error while trying to execute in SQL Server: </p>
  
  <blockquote>
    <p>Msg 156, Level 15, State 1, Procedure sql_chp4a_premiere_assign, Line 5<br>
    Incorrect syntax near the keyword 'SELECT'.</p>
  </blockquote>
  
  <p>I assume it refers to the first <code>SELECT</code>. I'm not very familiar with SQL just yet (as well as not having had class in awhile due to horrible storms and Spring Break) so it's probably something stupid I've overlooked.</p>
  
  <pre><code>USE [school username that gives out my name)
  
  CREATE PROCEDURE sql_chp4a_premiere_assign
  
  SELECT PART_NUM,DESCRIPTION,PRICE 
  FROM PART;
  
  SELECT *
  FROM ORDERS
  
  SELECT CUSTOMER_NAME 
  FROM customer 
  WHERE CREDIT_LIMIT&gt;=10000;
  
  SELECT ORDER_NUM
  FROM ORDERS
  WHERE CUSTOMER_NUM = '608'
  AND ORDER_DATE = '2010-10-23';
  
  SELECT CUSTOMER_NUM,CUSTOMER_NAME 
  FROM CUSTOMER 
  WHERE REP_NUM=35 OR REP_NUM=65;
  
  SELECT PART_NUM,DESCRIPTION 
  FROM PART WHERE CLASS!='AP';
  
  SELECT PART_NUM,DESCRIPTION,ON_HAND 
  FROM PART 
  WHERE ON_HAND BETWEEN 10 AND 25;
  
  SELECT PART_NUM,DESCRIPTION,ON_HAND 
  FROM PART 
  WHERE ON_HAND&gt;=10 AND ON_HAND&lt;=25;
  
  SELECT PART_NUM,DESCRIPTION,(ON_HAND * PRICE) 
  AS "ON_HAND_VALUE" 
  FROM PART WHERE CLASS='SG';
  
  SELECT PART_NUM,DESCRIPTION,(ON_HAND * PRICE) 
  AS "ON_HAND_VALUE" 
  FROM PART 
  WHERE (ON_HAND * PRICE)&gt;7500;
  
  SELECT PART_NUM,DESCRIPTION,(ON_HAND * PRICE) 
  AS "ON_HAND_VALUE" 
  FROM PART WHERE (ON_HAND * PRICE)&gt;7500;
  </code></pre>
  
  <p>Thanks, I really appreciate any help.</p>