Here's another method.  I got this idea for Piet Linden's post above.  We could work on the dates as he suggested because your latest data has overlapping date ranges but...

Sure...

If we look at the original...

And there's the rub.  Please provide 5 to 10 rows of readily consumable data for use to operate...

Alan... you might want to explain what the bernieML.samd. stuff is.

There should be an additional lesson learned here... when doing modifications to rows,  start with BEGIN TRANSACTION and then run the UPDATE.  If the rowcount is right, then COMMIT else...

You can have a look at sys.dm_db_index_usage_stats() to see if there have been any reads or writes since the last time the SQL Server Service was started.

Once you've decided that...

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