Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 parsing an xml file into a table

Author  Topic 

matnyc2000
Starting Member

16 Posts

Posted - 2007-09-07 : 16:50:32
Hi,

Am trying to parse an xml string that contains tab-delimited data. Looks like this:

<?xml version="1.0" encoding="utf-16"?>
<string>0
SUCCESS
name1@sql.com
name2@sql.com
name3@sql.com</string>

How do I parse this in order to put the data in a table. The table would have one column to store email addresses.

any ideas?
   

- Advertisement -