SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



Table-Valued Function to Split Strings with Xml Expand / Collapse
Author
Message
Posted Tuesday, June 30, 2009 4:44 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, February 08, 2010 1:05 PM
Points: 48, Visits: 90
Comments posted to this topic are about the item Table-Valued Function to Split Strings with Xml
Post #744977
Posted Wednesday, July 08, 2009 5:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:03 PM
Points: 1,679, Visits: 2,067
There are some characters that are "special" to XML; if they are present in the string they will cause the string to not be converted into XML. If you're going to write a function for this, then you really need to include converting those characters is present so that it will still work.

Wayne
For better assistance in answering your questions, click here.
For performance problems, please read this.
For common date/time routines, click here.
For CROSS-TABS and PIVOT tables, click on Part 1 and Part 2.
Post #749153
Posted Wednesday, July 08, 2009 7:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 15, 2010 6:16 AM
Points: 185, Visits: 355
Can you please elaborate Wayne.



View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Post #749258
« Prev Topic | Next Topic »


Permissions Expand / Collapse