title: Created a stored procedure in SQL Server Management Studio
body: <p>I am still quite new to this but am ready to take the next step. I am trying to execute multiple queries at once, if at all possible. From reading some other questions, it seems as if creating a stored procedure is the best route. </p>
  
  <p>The task at hand is creating 36 reports. In this case, hoping to create all 36 reports at one time and not have the results be one continuous entity. Each uses a query very similar to the code shown below. The query shown below is simply the first report to be created out of 36. The only difference in the 36 is the values in the WHERE statement. I am hoping for an operation or method that keeps me from copying and pasting 36 chunks of code into SQL and then copying and pasting those results into an excel spreadsheet. </p>
  
  <p>So my question is 1. Can this be done? 2. Is a stored procedure the best method for this task?</p>
  
  <pre><code>SELECT
      '000000' AS area,
      [SizeClass],
      COUNT(*) AS [Number of Worksites],
      SUM(Employment) AS [Employment In Size Class]
  FROM
      dbo.sizeclassreport
  WHERE 
      code LIKE '11%' OR code LIKE '21%'
  GROUP BY
      [SizeClass]
  ORDER BY
      [SizeClass]
  </code></pre>