The Original string is coming from a varbinary field.  I might have solved this using a cursor and the group number from output of DelimitedSplit8K.

Sorry for the delay.  I'm sure I'm not the only one with multiple projects and DAILY priority changes.

Here is some sample data

I have already used DelimitedSplit8K to pull the data...

Thank you all so much.  I will need to do more than just "Look at the second half of the article".  I have read it twice and will read it...

Sorry Steve the output I provided was only what a partial.  I did run exactly what was provided and here is a screen shot of everything including what I found...

Tally table, ok I am vaguely familiar, but really clueless.  A tally table is used in the DelimitedSplit8K function and I am guessing that this tally table would need to...

There will not be a large number of rows only a hundred or so at a time.  Do you have that function that you might care to share it?  I...

I did originally post this question under my personal account and this is from my work account.

I did think about using a second replace statement but could not devise the...

Phil - Correct.  Devs want it all in dev.

Ken - AWESOME  "INSTEAD OF"  Why didn't I think of that.  Is a trigger to delete  ##  history table records WHEN (sys.partitions.rows...

Thank you.

Performance.

This was a request that came in as an attempt to eliminate cross database queries made by the stored procedure that gathers data from 11 different tables across 3 different...

Thank you all !!

This is a DEV server and sometimes DBs are recreated from TFS.

You are correct though.  My initial thought was to capture the change in size as a positive value, but...

Thanks , that's great...

How does it know when data has changed?  Does Change Tracking need to be enabled?