If that's what is coming out of ChatGPT, then my job is still safe for the time being.

All 3 of CGPT queries are doing an update of the entire...

• This reply was modified 2 years, 6 months ago by Jonathan AC Roberts.

You can get an answer to your question by just pasting it into ChatGPT:

Query 1:

UPDATE [SF_Title_Update]
SET [Title_Proper] = 
    CASE 
   ...

Please let me know how long the procedure takes with the updated SQL.

I corrected that in my previous comment.

;WITH CTE AS
(
    SELECT DISTINCT [VID],[OrdDate],[Prg1],[Prg2],[Prg3],[Prg4],[Prg5],[Prg6],[RowUpdatDateTime]
      FROM #new
),
CTE2 AS
(
    SELECT...

UPDATE t
   SET t.Title_Update = CONCAT(T1.Descr, T2.Descr)
  FROM YourTable t
 CROSS APPLY(VALUES (CASE
           ...

When you do the insert you just need to select the most recent row for that [VID] on the #new table.

You can do this with a CTE, for the example...

• This reply was modified 2 years, 6 months ago by Jonathan AC Roberts. Reason: fixed aliases to make queries work

Not that carefully. I've just typed in roughly the same question as I can't remember exactly what it was, also ChatGPT has some randomness built in so doesn't arrive at...

You might need some new statistics. Put the query into "Database Engine Tuning Advisor" in SSMS and see if it suggest some new statistics.

What errors does it give?

Do we have to find your previous post to work out what to do in this question?

I can't say I have ever used RIGHT JOIN. I think it is only in the language for completeness.

Are you sure? I struggle to understand cursors ate the best of times, but I think the set based solution...

Given the OP stated "I run a script that brings the data that was modified in the last 24 hours from the 3rd party system" I assumed that the data...

Acceptable, perhaps.  But can you name any major RDBMS that...

I run a script that brings the data that was modified in the last 24 hours from the 3rd party system.

This table contains about 500,000 records for each day.

Then...

Where do you want to do the process? In Excel or in SQL Server?

It is the tradition on this forum that the poster of the question supplies the data in...