Alternatively:

;WITH CTE AS
(
    SELECT h1.hist_id, 
           'NEW' history,
      ...

• This reply was modified 7 months, 3 weeks ago by  Jonathan AC Roberts.
• This reply was modified 7 months, 3 weeks ago by  Jonathan AC Roberts. Reason: corrected

Thank you everyone.

This is very interesting.  Is this a bug within SS that you cannot drop a #temp table inside a SP using the DROP TABLE command?  Or is...

If the script is within a stored procedure it won't work,...

You need to add a GO before the second insert.

After reading again. I think this is what you want:

SELECT FP.UNDERLYING_SYMBOL,
       FP.QUOTE_DATE         ...

I think OUTER APPLY should work. I don't think this is quite correct as I'm not too sure about your specifications for what happens if nothing is found on the...

Are you expecting at most one row back for each UNDERLYING_SYMBOL, QUOTE_DATE?

Have you checked the logs for the Agent job?

From ChatGPT:

It seems like there's a formatting issue with your latitude and longitude values. The error message indicates that it's expecting a number but encountered something else at position 12...

You can download and install SQL Server Developer edition for free. Also, SSMS is free.

You can access the XML for an execution plan from the display of the plan. I...

I would guess that it would give the same recommendation in your scenario of moving it to a local machine compressing the tables.

If you just run the query with the...

;with cte as 
(
    select FacultyID,
           FacultyName,
       ...

You could insert them all as text columns then run another SQL process to convert them to your required format into a different table.

From ChatGPT:

Based on the provided XML deadlock graph, there are two victim processes (process4d93468 and process4cfdc28) involved in the deadlock. The deadlock occurred between two DELETE operations on the dbo.Logs_Epass...

Sometimes, a rise in CPU usage may occur due to table fragmentation. It might be beneficial to consider rebuilding the clustered indexes on those tables to assess whether it will...