title: Returning Data without Accesing a Table
body: <p>The Situation (Ignore this it is boring):
  I have reports that I created using reporting services. Some of these reports take the parameter, "Month". They enter in an integer for the month they want. Example: December = 12.
  In order to view the report, I am simply using the Report Viewer in visual studio. I need the month field to be a drop down box in order to select the month by name. There is a feature in in reporting services that allows you to bind the field to a stored procedure in order to create value/text pairs for the drop down list. </p>
  
  <p>The Problem:
  I don't want to create a "months" table in my database but I need to have a stored procedure that can return all the month/int pairs. I'm sure there is a very easy solution to this but I'm not sure what it is!  My first thought was creating a temp table, but I am not sure how to add manually add each month/int pair to the table... All your suggestions are appreciated!</p>
  
  <p>What I want is the following statement, except without the use of the Months Table:</p>
  
  <pre><code>SELECT MonthID, MonthName
  FROM Months
  </code></pre>