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...

BWAAA-HAAA-HAAA!!!.  Now there's a...

I don't know of a windows-driven "interrupt" that would do it (and, if someone does, please fire a flare 'cuz I'l love to know it!) but, if if there was...

It's difficult to produce such a list of new functionality even when restricted to just those for T-SQL.

One of my OMG! favorite improvements was when the came out with STRING_AGG()...