Sorry... duplicate post deleted.

Welcome aboard!

Rather than me explaining the things in the code that I demo, here are some references that do a better job than I could do.  Code specific to your...

Freakin' awesome test post, Jonathan.  Well done, good Sir!!!  This also proves something else... code written to do a specific task is highly likely to blow generic methods out of...

I need to split the column 'DiagnosisCodes' into 4 new columns 'Diagnosis1', 'Diagnosis2', 'Diagnosis3' and 'Diagnosis4' for the unique ChartProcedureId's. If they add more DiagnosisCodes, I only need the...

I think you can beat any splitting function by splitting in code with no need for aggregation.

As there are only a maximum of 4 values you can...

That's one of the reasons why I want to see both the Backup and DBCC commands that are being used.  We don't know what the OP is actually using.

Heh... the previous post was SPAM about a "diet plan" that recommended ingesting cotton balls as part of the diet.  I agree that's a bit ridiculous.

In that same vein, you...

To start with, please post one of the actual backup commands that gets executed.  Obfuscate the name of the database and any machine names the command may contain but don't...

 I wrote some T-SQL to read the first row (which contained the column names) and had it create a CREATE TABLE statement from that header and the BCP...

I think you can beat any splitting function by splitting in code with no need for aggregation.

As there are only a maximum of 4 values you can safely use...

That's a good start.

When I was hot and heavy into doing a shedload of them for a whole bunch of different files, I wrote some T-SQL to read the first...

Same problem in that article that many have.  The author ends it with a conclusion of "My final conclusion is that this is a really awesome tool to...

p.s.  And I disagree... getting FORMAT files right isn't really a fright in my book.

Where are the files located?  Sounds like a strange question but you have a file path of 'C:\SQLData\WRsales\' for both the data and format files.  Understand that file path is...

When I wrote this reply https://www.sqlservercentral.com/forums/topic/sql-server-database-redunduncy#post-4148195 and pressed submit I got an error "Are you sure you want to do that?"

I could be missing the obvious but I'm not...