SQLXML Bulkload multiple rows with parent node reference
- From: JeffHTu@xxxxxxxxx
- Date: Tue, 14 Aug 2007 13:14:01 -0700
How do you specify the annotated XSD for the following XML:
<Portfolio>
<AccountNumber>1234</AccountNumber>
<Securities>
<Symbol>IBM</Symbol>
<Symbol>AAPL</Symbol>
<Symbol>DELL</Symbol>
</Securities>
</Portfolio>
I would like the table to contain:
1234 IBM
1234 AAPL
1234 DELL
Howerver, the annotated XSD schema I came up with give me an error:
Data mapping to column 'Symbol' was already found in the data. Make
sure that no two schema definitions map to the same column.
In this case, how do you reference the parent AccountNumber for each
instance of the Symbol?
.
- Prev by Date: Re: Convert NTEXT to XML for use in following query.
- Next by Date: SQL, XML, and TableAdapters
- Previous by thread: SubQuery
- Next by thread: SQL, XML, and TableAdapters
- Index(es):
Loading