Extract elements in xml to rows in select statement
I have got xml column in my sql server 2008 database. XML sample in each row of my table

    <document>
     <part1>
       <listitem>val1</listitem>
       <listitem>val2</listitem>
       <listitem>val3</listitem>
     </part1>
     <part2>
       <listitem>val4</listitem>
     </part2>
    </document>

I would like to select all </listitem> elements from all rows. From sample above I should get four rows with listitem value.
Extract elements in xml to rows in select statement
===

I have got xml column in my sql server 2008 database. XML sample in each row of my table

    <document>
     <part1>
       <listitem>val1</listitem>
       <listitem>val2</listitem>
       <listitem>val3</listitem>
     </part1>
     <part2>
       <listitem>val4</listitem>
     </part2>
    </document>

I would like to select all </listitem> elements from all rows. From sample above I should get four rows with listitem value.