deepak
8/6/2007 12:04:00 PM
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
>