title: exec sp_xml_preparedocument with external column
body: <p>I have this table </p>
  
  <pre><code>declare  @temp_xml table
  (
      question_id int,
      question_xml xml
  )
  
  insert into @temp_xml(question_id, question_xml)
  values(51, '&lt;qst qodm="Horizontal" oprm="New Line" oph="25" opw="200" stext=""   filepath="" peqid="-1" peaid="-1" pipeqtype="1" rad="False"&gt;&lt;cps&gt;&lt;qvs qvid="V1" qvt="Required" qvem="Please choose at least one answer." /&gt;&lt;qvs qvid="V15" qvt="UK Phone Number " qvem="Is not a correct phone format." /&gt;&lt;/cps&gt;&lt;branch&gt;&lt;![CDATA[]]&gt;&lt;/branch&gt;&lt;/qst&gt;'
        ),
        (52,
     '&lt;qst qodm="Horizontal" oprm="New Line" oph="25" opw="200" stext="" filepath="" peqid="-1" peaid="-1" pipeqtype="1" rad="False"&gt;&lt;cps&gt;&lt;qvs qvid="V1" qvt="Required" qvem="Please choose at least one answer." /&gt;&lt;qvs qvid="V5" qvt="US/Canada  Phone Number " qvem="Is not a correct phone format." /&gt;&lt;/cps&gt;&lt;branch&gt;&lt;![CDATA[]]&gt;&lt;/branch&gt;&lt;/qst&gt;'
        )
  
  select * from @temp_xml
  </code></pre>
  
  <p>Now I want to show like this .</p>
  
  <pre><code>   Question_id  qvt                       qvem
     51,          Required,                 Please choose at least one answer.
     51,          UK Phone Number,          Is not a correct phone format.
     52,          Required,                 Please choose at least one answer.
     52,          US/Canada  Phone Number,  Is not a correct phone format.
  </code></pre>
  
  <p>any one can help me out ?</p>
  
  <p>Thanks.</p>