title: CREATE VIEW must be the only statement in the batch
body: <p>I'm trying to make a view.  So far, I have written this:</p>
  
  <pre><code>with ExpAndCheapMedicine(MostMoney, MinMoney) as
  (
      select max(unitprice), min(unitprice)
      from Medicine
  )
  ,
  findmostexpensive(nameOfExpensive) as
  (
      select tradename
      from Medicine, ExpAndCheapMedicine
      where UnitPrice = MostMoney
  )
  ,
  findCheapest(nameOfCheapest) as
  (
      select tradename
      from Medicine, ExpAndCheapMedicine
      where UnitPrice = MinMoney
  )
  
  CREATE VIEW showing
  as
  select tradename, unitprice, GenericFlag
  from Medicine;
  </code></pre>
  
  <p>Unfortunately, I get an error on the line containing <code>CREATE VIEW showing</code></p>
  
  <blockquote>
    <p>"CREATE VIEW must be the only statement in the batch"</p>
  </blockquote>
  
  <p>How can I fix this?!</p>