Hello everyone,

I need your help. I have a “datetime” column (data type is Varchar(64) )with the following content: Sun Sep 29 2024 09:28:55 GMT+0000 (Coordinated Universal Time)

I would...

Try this... notice the only change is a couple of left outer join's for the drivers table (the word OUTER is optional... I left it out). I not only did...

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