Oh, and this:

https://kc.mcafee.com/corporate/index?page=content&id=KB91467

“With the Windows April 2019 updates, the Client Server Runtime Subsystem (CSRSS) operating system process CSRSS.EXE performs file I/O more frequently while fulfilling LoadLibrary requests from...

GAAAAHHHH.

So apparently those wonderful April updates affect McAfee as well as the others. We've been chasing issues for the past few weeks and it wasn't until we started looking at...

Danke!

Wow. So apparently I learn something new every day with SQL Server. Yesterday, I accidentally learned that if you highlight a section of code in a SSMS query...

Sorry I didn't have a chance to respond yesterday. It was very busy at work.

But yes, that's exactly my problem. What Sue said and what you posted.

Yeah, I saw someone post about that one several months ago and I've been using it ever since.

Previously we'd been doing that in UltraEdit. It was nice to know I...

Wow. So apparently I learn something new every day with SQL Server. Yesterday, I accidentally learned that if you highlight a section of code in a SSMS query window and...

Thank you all for your responses. I'm choosing not to go with either of the additional solutions because I'm trying to cut down the code I have rather than add...

<headdesk>. Wow. How did I miss this?

SELECT DATEDIFF(hh,CONVERT(DATE,GETDATE(),120),CONVERT(DATETIME,(RIGHT(LEFT(SubDirectory,LEN(SubDirectory)-8),8))))
+ DATEDIFF(hh,CONVERT(TIME,GETDATE()),CONVERT(TIME,(SUBSTRING(Subdirectory,20,2) + ':' + SUBSTRING(Subdirectory,22,2) + ':00.0000000'),120)) AS HrsAged, Subdirectory
--INTO #PurgeBackups
FROM #DirTree;

And apparently I can't bold the changed parts...

My database is too large. Restoring headers takes far too long for this operation. I need it to be quick. The code above completes in less than a minute.

I down voted everything on that post.  None of the people involved including the original poster, the two people that posted the answers, the idiot that edited the original...

Can you please post the DDL for the tables and the sample data? IE, table creates and inserts for the sample data.

It's mighty hard to read the images you've inserted...

I don't have a Stack Overflow account, let alone a 50 rep on the site. Since the topic is still open, maybe could someone able to post to the site...

Annnnnddddd...

Because I just realized y'all are going to ask.

https://stackoverflow.com/questions/35951765/the-metadata-could-not-be-determined-because-every-code-path-results-in-an-error

Yesterday night, a job failed with a weird error I'd never seen before. I hop onto Google this morning to search for it and find all sorts of interesting responses....