xml to SQL table

Question

Guys!

I have a below table where the Address is in xml

UserId

Name

Address

1

Johny

1Johny

Johny StNew York08237

2

Harry

2Harry

Brook Side101Harry StVirginia04234

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?

Vishvjit Shinde · Accepted Answer

Hi, Please check this Articles:  https://www.codeproject.com/Articles/1073184/How-to-import-data-into-MS-SQL-server-from-CSV-and   https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/    Videos:  https://www.youtube.com/watch?v=FOVROz5wc64

Shweta Lodha · Answer

Please refer this; https://www.mssqltips.com/sqlservertip/5707/simple-way-to-import-xml-data-into-sql-server-with-tsql/