Convert xml to table in sql

Question

Hi,

I have an xml in following format,
I want to convert the below XML to the table in sql.the output has to be something like this.
Does anyone done this before??

---Output----

ExternalProvider_ID

ZZZZZ00003

ZZZZZ00006

ZZZZZ00009

ZZZZZ0000E

-----XML----

<NewDataSet>

<Table1>

<TableID>ZZZZZ00003</TableID>

</Table1>

<Table1>

<TableID>ZZZZZ00006</TableID>

</Table1>

<Table1>

<TableID>ZZZZZ00009</TableID>

</Table1>

<Table1>

<TableID>ZZZZZ0000E</TableID>

</Table1>

</NewDataSet>