----------------------------------------------------------- New Message on AhmedabadUserGroup
----------------------------------------------------------- From: jacobseb Message 1 in Discussion Hi, SQL Server 2005 introduced the XML data type. Thought the XML data type is designed to store and manage XML documents, it can be used to solve a number of other problems. The XML data type methods are very much helpful while working with delimited strings. I had earlier written a post that demonstrates how to generate a delimited string using FOR XML. You can find the post here: http://www.sqlserverandxml.com/2008/08/how-to-generate-delimited-string-using.html. Then I wrote a follow-up post that demonstrates the opposite of that: parsing a delimited string using XML method. You can find the post here: http://www.sqlserverandxml.com/2008/08/xquery-lab-19-how-to-parse-delimited.html Today, I would like to present one more example where an XML approach is used to solve a TSQL problem. The example presented in the following article uses XML method to parse a delimited string and then matches each value with a column that contains comma delimited strings. http://www.sqlserverandxml.com/2008/09/tsql-labs-13-matching-delimited-string.html Regards Jacob Sebastian, SQL Server MVP ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/AhmedabadUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]