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

There aren't any joins in the query...

Thank you Scott and Jonathan.

Hi Jonathan, question came into mind, if the batch size is specified as 1000 but assuming if the qualified rows based on where condition is...

DECLARE @BatchSize INT = 1000; -- Adjust batch size as needed
DECLARE @RowsAffected INT...