title: SQL Selecting column names as values
body: <p>I have a table of data with column names:</p>
  
  <pre><code>period, Truck, Car, Boat
  </code></pre>
  
  <p>Where the Columns contain numeric values, and the period column is an identity column having 1 to 48, so there are 48 rows.</p>
  
  <p>I would like to massage this table into a format where I have a Name column and a value column as well as the period column eg.</p>
  
  <pre><code>period, NameOfVehicle, Value
  </code></pre>
  
  <p>I want to create a view of the orignal table to do this? How can I select the column names and place them and the correct value from that column into the NameOfVehicle and Value columns?</p>