As pietlinden said, delimitedsplit8K is the way to go.  You could do something like this: 

DECLARE @FieldName VARCHAR(50)
SET @FieldName='#1550000#2099#14400#154006#15400#0#10#';

SELECT
  Mon...

LAs Jeff zaid - your value is being sorted as text. You need to change the column data type to a percentage for that column.

The best thing you can do is, if possible, lose the XML column, get this data into 3NF then index accordingly. If this is not an option then consider adding...

Well done - great collection of useful info. 

I will advise, however, developers avoid using GO for inserting sample data as it would be horrifically slow. 

For example,...

I started using IS with SQL Server 2005 because I was told, or read somewhere, that they were better; I don't believe this anymore. I use them now more often...

This will differ from company to company based on the size of the company, it's governance and size. Often I've seen the database people (e.g. DBA, SQL/BI Developers/Data Scientists) as...

I always enjoy seeing different approaches to handling fuzzy matching in SQL Server. That said, there are many issues with this approach that I don't want to dive into that...