I concur with the error found by Jeff Williams.  I also concur with the OUTER APPLY method being faster.  With the correct index, it's actually twice as fast as the...

Since the author of that article hasn't answered the latest question there in over 4 years, why not just try it and see?  Then, you can answer poor Jose's question...

To be sure, that's not "SQL Server".  There's no such thing as SQL Server 20.2.  What you're seeing is SQL Server Management Studio, which is also known as "SSMS".  That's...

Thank you for the feedback!

To follow up on Eddie Wuerch's good post, it's an old but powerful bit of ancient code known as a CROSSTAB.  You can get a good introduction to them in...

I'm not a ninja at it but you could try it in a "Maintenance Plan".  To execute a proc, you would use an execute SQL block.  You could have the...

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