SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

DECLARE 
    @x xml;  
SET 
    @x='<event name="blocked_process_report" package="sqlserver" timestamp="2022-11-06T14:38:50.569Z">
  <data name="duration">
    <value>20887000</value>
  </data>
  <data name="database_id">
    <value>5</value>
  </data>
  <data name="object_id">
    <value>0</value>
  </data>
  <data name="index_id">
    <value>0</value>
  </data>
  <data name="lock_mode">
    <value>3</value>
    <text>S</text>
  </data>
  <data name="transaction_id">
    <value>23200057</value>
  </data>
  <data name="resource_owner_type">
    <value>0x00000001</value>
    <text>LOCK</text>
  </data>
  <data name="blocked_process">
    <value>
      <blocked-process-report monitorLoop="191492">
        <blocked-process>
          <process id="process23696fb68c8" taskpriority="0" logused="0" waitresource="PAGE: 5:5:1476835 " waittime="20887" ownerId="23200057" transactionname="SELECT" lasttranstarted="2022-11-06T06:38:29.677" XDES="0x2369a9ebaa0" lockMode="S" schedulerid="5" kpid="5100" status="suspended" spid="57" sbid="0" ecid="1" priority="0" trancount="0" lastbatchstarted="2022-11-06T06:38:29.677" lastbatchcompleted="2022-11-06T06:38:22.943" lastattention="1900-01-01T00:00:00.943" clientapp="Microsoft SQL Server Management Studio - Query" hostname="NADASAVAGE" hostpid="20084" isolationlevel="read committed (2)" xactid="23200057" currentdb="5" currentdbname="StackOverflow2013" lockTimeout="4294967295" clientoption1="671090784" clientoption2="390200">
            <executionStack>
              <frame line="1" stmtend="108" sqlhandle="0x020000008d18260040e407ba48fc247b0cb6121c21c2cf2b0000000000000000000000000000000000000000" />
              <frame line="1" stmtend="108" sqlhandle="0x02000000dd847b18dcaa4a09a89f56595186fcf91da8a7f70000000000000000000000000000000000000000" />
            </executionStack>
            <inputbuf>
SELECT * FROM dbo.Votes AS v WHERE v.BountyAmount &gt; 550   </inputbuf>
          </process>
        </blocked-process>
        <blocking-process>
          <process status="sleeping" spid="52" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2022-11-06T06:38:27.290" lastbatchcompleted="2022-11-06T06:38:27.290" lastattention="1900-01-01T00:00:00.290" clientapp="Microsoft SQL Server Management Studio - Query" hostname="NADASAVAGE" hostpid="20084" loginname="sa" isolationlevel="read committed (2)" xactid="23200047" currentdb="5" currentdbname="StackOverflow2013" lockTimeout="4294967295" clientoption1="671090784" clientoption2="390200">
            <executionStack />
            <inputbuf>
BEGIN TRAN

UPDATE v SET v.BountyAmount = 1000  FROM dbo.Votes AS v WHERE v.Id = 1138   </inputbuf>
          </process>
        </blocking-process>
      </blocked-process-report>
    </value>
  </data>
  <data name="database_name">
    <value>StackOverflow2013</value>
  </data>
</event>';

SELECT 
    sql_handle = 
        @x.query('for $s in //executionStack/frame return $s');

There are multiple root elements. Line 1, position 137.
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
   at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
   at System.Xml.XmlDocument.Load(XmlReader reader)
   at System.Xml.XmlDocument.LoadXml(String xml)
   at ASP.index_aspx.PrettyXML(String XMLString)
   at ASP.index_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer)