xml to SQL table

Question

Guys!

I have a below table where the Address is in xml

UserId	Name	Address
1	Johny	<UserId>1</UserId><UserName>Johny</UserName><Address><Street>Johny St</Street><City>New York</City><ZipCode>08237</ZipCode></Address>
2	Harry	<UserId>2</UserId><UserName>Harry</UserName><Address><Appartment>Brook Side</Appartment><Number>101</Number><Street>Harry St</Street><City>Virginia</City><ZipCode>04234</ZipCode></Address>

I want a NEW table like this below

Userid	Name	Appartment	Number	Street	City	ZipCode
1	Johny			Johny St	New York	08237
2	Harry	Brook Side	101	Harry St	Virginia	04234

Can I get it with SQL Query/SP please?