title: Select values from XML field in SQL Server 2008
body: <p>Just looking at my XML field, my rows look like this:</p>
  
  <pre><code>&lt;person&gt;&lt;firstName&gt;Jon&lt;/firstName&gt;&lt;lastName&gt;Johnson&lt;/lastName&gt;&lt;/person&gt;
  &lt;person&gt;&lt;firstName&gt;Kathy&lt;/firstName&gt;&lt;lastName&gt;Carter&lt;/lastName&gt;&lt;/person&gt;
  &lt;person&gt;&lt;firstName&gt;Bob&lt;/firstName&gt;&lt;lastName&gt;Burns&lt;/lastName&gt;&lt;/person&gt;
  </code></pre>
  
  <p>Note that these are three rows in my table.</p>
  
  <p>I'd like to return a SQL result as a table as in</p>
  
  <pre><code>Jon  | Johnson
  Kathy| Carter
  Bob  | Burns
  </code></pre>
  
  <p>What query will accomplish this?</p>