title: Trying to get all xml nodes with SQL Server, what am I doing wrong?
body: <p>I have the following xml in a table cell, in column MyColumn:  </p>
  
  <pre><code>&lt;BSDL xmlns="..." xmlns:i="..."&gt;
    &lt;dateTime&gt;2012-12-30T00:00:00Z&lt;/dateTime&gt;
    &lt;dateTime&gt;2013-01-07T00:00:00Z&lt;/dateTime&gt;
    &lt;dateTime&gt;2013-01-14T00:00:00Z&lt;/dateTime&gt;
    &lt;dateTime&gt;2013-01-21T00:00:00Z&lt;/dateTime&gt;
    &lt;dateTime&gt;2013-01-29T00:00:00Z&lt;/dateTime&gt;
    &lt;dateTime&gt;2013-02-05T00:00:00Z&lt;/dateTime&gt;
    &lt;dateTime&gt;2013-02-12T00:00:00Z&lt;/dateTime&gt;
    &lt;dateTime&gt;2013-02-19T00:00:00Z&lt;/dateTime&gt;
    &lt;dateTime&gt;2013-03-22T00:00:00Z&lt;/dateTime&gt;
    &lt;dateTime&gt;2013-03-29T00:00:00Z&lt;/dateTime&gt;
    &lt;dateTime&gt;2013-04-19T00:00:00Z&lt;/dateTime&gt;
  &lt;/BSDL&gt;  
  </code></pre>
  
  <p>I'm just trying to query it (get all xml nodes) using:  </p>
  
  <pre><code>SELECT BSDL.item.value('(dateTime)[1]', 'datetime')
      from [MyTable]
      CROSS APPLY [MyColumn].nodes ('//BSDL') BSDL(item)  
  </code></pre>
  
  <p>it yields no result, although my <code>MyColumn</code> in <code>MyTable</code> has the same number of entries as above, for each row.</p>