title: Convert XML datatype in SQL 2005 into a relational resultset
body: <p>I have a table in a SQL 2005 database that contains a column defined as a xml datatype.  I'm trying to write stored proc that queries the xml and returns a resultset from a select statement.  I've seen examples of returning scalar values or xml but not how to return a resultset.</p>
  
  <p>Am I going to have to use openxml or is there another solution?</p>