Hi All,

How to sum up the following numeric numbers in <In Progress> tag using T-Sql
or Oracle
query.There are thousands of tags rows in a column in the table. i need sum
of numeric value present in the <InProgress> tag

e.g. 2 tags shown below
Tag 1:

<S><Unassigned>3</Unassigned><Assigned>1</Assigned><Dispatched>20</Dispatched><Jeopardy-NotAccepted>74</Jeopardy-NotAccepted><Accepted>1073</Accepted><InProgress>6424</InProgress></S>

Tag 2:

<S><Unassigned>5</Unassigned><Assigned>2</Assigned><Dispatched>44</Dispatched><Accepted>33</Accepted><InProgress>22</InProgress></S>

Note :There are thousands of tags rows in a column in the table


Thanks,
Deepak
MCPD.NET
kr_deepak123 (AT) hotmail (DOT) com

Also, the <InProgress> tag can be on any place like

Tag 1:

<S><Unassigned>3</Unassigned><Assigned>1</Assigned><Dispatched>20</Dispatched><Jeopardy-NotAccepted>74</Jeopardy-NotAccepted><Accepted>1073</Accepted><InProgress>6424</InProgress></S>

Tag 2:

<S><Unassigned>3</Unassigned><Assigned>1</Assigned><Accepted>1073</Accepted><InProgress>6424</InProgress></S>


"deepak" wrote: