MS SQL XML - Import XML

Author

Import XML

LuMa

2005-07-06, 7:23 am

Hi, i need to sum data in Level 2 . The records in Level 3 must be in one
row, but i must to know value of Level 3 . It’s important for me string in “
“. . The best solution is to get value from level to every row in the same
row. But how.
Thanks for your help and apologize my english, Lubo

There is source ....

<?xml version="1.0" encoding="UTF-8"?>
<Level 1>
<REFC>789a45</REFC>
<ADR>Footbal Club</ADR>
<FA>30.13.8965</FA>
<DA>1.7.2001</DA>
<CEN>99999,9</CEN>
<Level 2>
<LEVEL 3="12345">
<Vola>
<Vole>
<D_tm>04.04.</D_tm>
<Time>08:39:- 08:40</Time>
</Vole>
<Vole>
<D_tm>29.04.</D_tm>
<Time>14:03 - 05:21</Time>
</Vole>
</Vola>
</LEVEL 3>
<LEVEL 3="23456">
<Vola>
<Vole>
<D_tm>12.04.</D_tm>
<Time>3:53: - 3:55</Time>
</Vole>
<Vole>
</Vola>
</LEVEL 3>
<LEVEL 3="23458">
<Vola>
<Vole>
<D_tm>01.04.</D_tm>
<Time>1:50:52 - 2:03:57</Time>
</Vole>
<Vole>
<D_tm>01.04.</D_tm>
<Time>16:12 - 16:17</Time>
</Vole>
<Vole>
<D_tm>03.04.</D_tm>
<Time>12:23:29 - 12:30:41</Time>
</Vole>
</Vola>
</LEVEL 3>
</Level 2>
<OZ> TEXT ..... </OZ>
</Level 1>

Bertan ARI [MSFT]

2005-07-14, 3:23 am

Are you already using some technology to transform the Xml data like OpenXml
or looking for a technology to achieve what you want?

--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.

"LuMa" <LuMa@discussions.microsoft.com> wrote in message
news:6D380253-173B-4C0F-9B17- 2B9A4D5EFEC8@microso
ft.com...
> Hi, i need to sum data in Level 2 . The records in Level 3 must be in one
> row, but i must to know value of Level 3 . It's important for me string in
> "
> ". . The best solution is to get value from level to every row in the
> same
> row. But how.
> Thanks for your help and apologize my english, Lubo
>
> There is source ....
>
> <?xml version="1.0" encoding="UTF-8"?>
> <Level 1>
> <REFC>789a45</REFC>
> <ADR>Footbal Club</ADR>
> <FA>30.13.8965</FA>
> <DA>1.7.2001</DA>
> <CEN>99999,9</CEN>
> <Level 2>
> <LEVEL 3="12345">
> <Vola>
> <Vole>
> <D_tm>04.04.</D_tm>
> <Time>08:39:- 08:40</Time>
> </Vole>
> <Vole>
> <D_tm>29.04.</D_tm>
> <Time>14:03 - 05:21</Time>
> </Vole>
> </Vola>
> </LEVEL 3>
> <LEVEL 3="23456">
> <Vola>
> <Vole>
> <D_tm>12.04.</D_tm>
> <Time>3:53: - 3:55</Time>
> </Vole>
> <Vole>
> </Vola>
> </LEVEL 3>
> <LEVEL 3="23458">
> <Vola>
> <Vole>
> <D_tm>01.04.</D_tm>
> <Time>1:50:52 - 2:03:57</Time>
> </Vole>
> <Vole>
> <D_tm>01.04.</D_tm>
> <Time>16:12 - 16:17</Time>
> </Vole>
> <Vole>
> <D_tm>03.04.</D_tm>
> <Time>12:23:29 - 12:30:41</Time>
> </Vole>
> </Vola>
> </LEVEL 3>
> </Level 2>
> <OZ> TEXT ..... </OZ>
> </Level 1>

Sponsored Links