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 |
|
AAAV
Posting Yak Master
152 Posts |
 Posted - 2010-07-22 : 11:08:22
|
| i have a xml to parse with each record having nodespart1, part2, part3.... part15in each row has n parts max.row 1 might have 3 parts row 2 might have 5 parts and so son.SELECT a.b.value('./part1[1]','int') as part1, a.b.value('./part2[1]','int') as part,....... a.b.value('./part1[15]','int') as part15, FROM @xmlData.nodes('Root/VehicleDetails')a(b)Here the xml parser has to go only till it reaches the null beyond that it is def null. Is there a way for me to do a condition on the parsing?is there a better way to do it.The reason is the input files are too huge and at some point the sql server just hangs.Thanks |
|
|
|
|
|
parse xml conditionally