Summing up numeric values using Oracle or T-SQL query

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@hotmail.com

Date:Mon, 6 Aug 2007 04:32:02 -0700 Author:

Summing up numeric values using Oracle or T-SQL query

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:


> 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@hotmail.com
>

Date:Mon, 6 Aug 2007 05:04:02 -0700 Author: