Having never used SQL for anything serious I have been asked to look at importing multiple data files into a database and have come to a dead stop. The XML file is a repeating structure with but the number of <SampleVial>s and the number of <Particles>s in each file is a variable...example shown below
<AcquisitionIntervals>
<SampleVial id="1">
<AcquisitionInterval>
<StartOfIntervalUpdate>
<Id>0</Id>
<ElapsedTime>0.354070258140564</ElapsedTime>
<VialIndex>0</VialIndex>
<CycleIndex>0</CycleIndex>
<Mass>-1</Mass>
<TotalNumberOfParticlesThroughSensor>0</TotalNumberOfParticlesThroughSensor>
<TotalVolumeThroughSensor>0</TotalVolumeThroughSensor>
</StartOfIntervalUpdate>
<Particles>
<AcquisitionUpdate>
<Id>1</Id>
<ElapsedTime>0.357820471127828</ElapsedTime>
<VialIndex>0</VialIndex>
<CycleIndex>0</CycleIndex>
<Mass>44.407905648898</Mass>
<TotalNumberOfParticlesThroughSensor>1</TotalNumberOfParticlesThroughSensor>
<TotalVolumeThroughSensor>0.000151105559071708</TotalVolumeThroughSensor>
</AcquisitionUpdate>
<AcquisitionUpdate>
<Id>2</Id>
<ElapsedTime>0.357820471127828</ElapsedTime>
<VialIndex>0</VialIndex>
<CycleIndex>0</CycleIndex>
<Mass>62.5123878057821</Mass>
<TotalNumberOfParticlesThroughSensor>2</TotalNumberOfParticlesThroughSensor>
<TotalVolumeThroughSensor>0.000151105559071708</TotalVolumeThroughSensor>
</AcquisitionUpdate>
</Particles>
<EndOfIntervalUpdate>
<Id>3</Id>
<ElapsedTime>1.0134746392568</ElapsedTime>
<VialIndex>0</VialIndex>
<CycleIndex>0</CycleIndex>
<Mass>-2</Mass>
<TotalNumberOfParticlesThroughSensor>304</TotalNumberOfParticlesThroughSensor>
<TotalVolumeThroughSensor>0.0425356529565674</TotalVolumeThroughSensor>
</EndOfIntervalUpdate>
</AcquisitionInterval>
</SampleVial>
<SampleVial id="2">
<AcquisitionInterval>
<StartOfIntervalUpdate>
I need to pull all of the particle data associated with each <SampleVial>. If anyone can point me in the right direction I would be very grateful.
Thanks for looking.
Pete