I read and tried many times, but I cannot successful build xml
my target xml as:
<Header>
<Body IsUpdate="Y">
<Name IsUpdate="Y">ABC Company</Name>
<Details>
<Line IsUpdate="Y">
<Feature IsUpdate="Y">Feature 1</Feature>
<Feature IsUpdate="N">Feature 2</Feature>
</Line>
</Details>
<Discount IsUpdate="Y">1120</Discount>
</Body>
</Header>
How to use Explicit Mode to build above XML?From what table(s) is this xml being composed?
Peter DeBetta, MVP - SQL Server
http://sqlblog.com
--
"ABC" <abc@.abc.com> wrote in message
news:uYc0$stwHHA.3364@.TK2MSFTNGP02.phx.gbl...
>I read and tried many times, but I cannot successful build xml
> my target xml as:
> <Header>
> <Body IsUpdate="Y">
> <Name IsUpdate="Y">ABC Company</Name>
> <Details>
> <Line IsUpdate="Y">
> <Feature IsUpdate="Y">Feature 1</Feature>
> <Feature IsUpdate="N">Feature 2</Feature>
> </Line>
> </Details>
> <Discount IsUpdate="Y">1120</Discount>
> </Body>
> </Header>
> How to use Explicit Mode to build above XML?
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment