Data From XML To Server 2005

Hi



I m new to the forum and to Server 2005



I have to transfer data from large XML files to Server 2005.I need to have the value from each text node as a row.


so here is a sample XML



<?xml ......>

<A>

<B time = 1>

<C> Value = something </C>

<D> Value = something</D>

......

</B>

</A>



<A>

<B time = 2>

<C> Value = something </C>

<D> Value = something</D>

......

</B>

</A>





What i want to do is have columns in Server 2005 table named B,C and D and store each time as a row in those coloumns . i want tp store just the value not the whole XML.



I am sure this is really basic .Can some one give me some direction as to how to do this



Thanks



~ Hem