Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-04-20 : 11:00:04
|
| Hi,Using openxml, how is it possible to get get the code values for each correlation element please?<Data> <date>19-Apr-2007</date> < <correlations> <correlation code="WTI NYMEX:WTI NYMEX">1</correlation> <correlation code="WTI NYMEX:BR IPE">12</correlation> <correlation code="WTI NYMEX:NG NGA">54</correlation> <correlation code="WTI NYMEX:AL LME">77</correlation> <correlation code="WTI NYMEX:CU LME">32</correlation> <correlation code="WTI NYMEX:NI LME">0.32</correlation> <correlation code="WTI NYMEX:PB LME">0.87</correlation> .........</correlations></Data>This is what I have so far:select @IndexName = code FROM OPENXML (@idoc, '/marketData/correlations',1) WITH ( code varchar(50), -- to hold the data in "" value varchar(50) -- to hold the number )Thanks |
|
|
|
|
|
openxml