First, thank you for helping us help you by posting the readily consumable data code.

Ed B.'s code is good, although I'll never use PIVOT because of the issue he pointed...

Thanks for this. It confirms my googling explroations, and I'm about to try it.

I wonder what will happen on those requests where a driver hasn't yet been allocated. They...

It turns out that I simply misread the dd/mm/yyyy format of the expected answer and the original code that I posted was just fine.  Here's that post again...

Apparently, you didn't...

Sorry... made a mistake... will repost in, hopefully, a couple of minutes.

Sorry... made a mistake... will repost in, hopefully, a couple of minutes.

Put the same table in the FROM clause twice using a JOIN.  The key will be to give each instance of the table a different alias... one called "Driver" and...

I'd also have a meeting with the 3rd party creators of the software and ask them to fix it.

As a bit of a sidebar, this is one of the many...

As Phil suggests, please provide the data in a readily consumable format instead of a graphic to help us help you.  See the first link in my signature line below...

I use those tools as a starting point for investigation and not as the truth.  Many times the end result of an investigation is modifying an existing index instead...

I'm going to advise some good caution here.  There are a ton of tools, including but not limited to SQL Server's built-in "missing indexes" tool but you should never just...

You can get the code for it in the "Resources" section at the following article, which explains how it works, as...

Thank you for the feedback.

When dealing with untrusted data, you'll need to use things like TRY_CONVERT().  If it fails, it will return a NULL.  Then you can go back to the original data and...

Jeff, The "url" link to the excellent article at the beginning of this discussion isn't working. I believe it should point to https://www.sqlservercentral.com/articles/hidden-rbar-triangular-joins, but only you have...

"Bump" to check for missing posts at start of new page.

Heh... turned out to be SPAM... took that out.