Sum of XML duration elements in SQL2008
- by Matt
I have a XML column that holds information about my games. Here's a sample of the information looks like.
<game xmlns="http://my.name.space" >
<move>
<player>PlayerA</player>
<start movetype="Move">EE5</start>
<end movetype="Move">DF6</end>
<movetime>PT1S</movetime>…