title: XMl parse in SQL Server
body: <p>I have this xml structure.I use the following  sql to read the values but it doesnt work</p>
  
  <pre><code>DECLARE @x XML =
  '&lt;Events&gt;
    &lt;Event DateTimeGMT="25/10/2013 18:45:00" Branch="Soccer" Sport="Soccer" BranchID="1" League="England - Championship" LeagueID="10099" ID="5693075" IsOption="0" EventType="0" MEID="2673883"&gt;
      &lt;Participants&gt;
        &lt;Participant1 Name="Middlesbrough" Home_Visiting="Home" /&gt;
        &lt;Participant2 Name="Doncaster" Home_Visiting="Visiting" /&gt;
      &lt;/Participants&gt;
      &lt;MoneyLine Home="1.69" Draw="3.7" Away="5" /&gt;
      &lt;Spread Home_Odds="1.885" Home_Points="-0.75" Away_Points="0.75" Away_Odds="1.962" /&gt;
      &lt;Total Points="2.75" Over="2.06" Under="1.763" /&gt;
    &lt;/Event&gt;
    &lt;Event DateTimeGMT="25/10/2013 18:45:00" Branch="Soccer" Sport="Soccer" BranchID="1" League="England - Championship" LeagueID="10099" ID="5693993" IsOption="1" EventType="200" MEID="2673883"&gt;
      &lt;Participants&gt;
        &lt;Participant1 Name="Middlesbrough" Home_Visiting="Home" /&gt;
        &lt;Participant2 Name="Doncaster" Home_Visiting="Visiting" /&gt;
      &lt;/Participants&gt;
      &lt;Total Points="4.5" Over="5.75" Under="1.125" /&gt;
    &lt;/Event&gt;
  &lt;/Events&gt;
  '
  DECLARE @iDoc INT
  EXECUTE sp_xml_preparedocument @iDoc OUTPUT, @x
  
  SELECT  *
  FROM    OPENXML(@iDoc,'/Events/Event')
  WITH    (
  ID int '@ID',
  DateTimeGMT [varchar](100) '@DateTimeGMT',
  Branch [varchar](100) '@Branch',
  Sport [varchar](100) '@Sport',
  BranchID int '@BranchID',
  League [varchar](100) '@League',
  LeagueID int '@LeagueID',
  IsOption int '@IsOption',
  EventType int '@EventType',
  MEID int '@MEID',
  QAID int '@QAID',
  EventName [varchar](500) '@EventName',
  Home [varchar](100) '../Event/Participants/Participant1/@Name',
  Away [varchar](100) '../Event/Participants/Participant2/@Name',
  [1] [varchar](5) '../Event/MoneyLine/@Home',
  [X] [varchar](5) '../Event/MoneyLine/@Draw',
  [2] [varchar](5) '../Event/MoneyLine/@Away',
  Spread_Home_Points float '../Event/Spread/@Home_Points',
  Spread_Home_Odds float '../Event/Spread/@Home_Odds',
  Spread_Away_Points float '../Event/Spread/@Away_Points',
  Spread_Away_Odds float '../Event/Spread/@Away_Odds',
  Total_Points float '../Event/Total/@Points',
  Lart float '../Event/Total/@Over',
  Posht float '../Event/Total/@Under'
          )
  
  EXECUTE sp_xml_removedocument @iDoc
  </code></pre>
  
  <p>But this doent give a correct answer. On the second row that doesnt fine MoneyLine it repeats the first row values.
  <img src="https://i.stack.imgur.com/aVXo3.png" alt="enter image description here"></p>
  
  <p>The values marked with circle showld be empty.Any help please?</p>