DECLARE @TableString AS nvarchar(MAX)
DECLARE @SqlString as nvarchar(MAX) = ''
DECLARE MyCursor cursor
FOR SELECT concat_ws('.',c.TABLE_CATALOG, c.TABLE_SCHEMA, c.TABLE_NAME) x
      FROM INFORMATION_SCHEMA.COLUMNS c
   ...

Couldn't it be as straightforward as this??

SELECT t.[pick your columns]
FROM SomeTable t
INNER JOIN (SELECT [ID#]
           ...

deleted - duplicate

• This reply was modified 1 years, 10 months ago by Jonathan AC Roberts.

It sounds like an exciting opportunity for SQL Architects! With a focus on building sustainable systems, improving database architecture, and guiding engineering teams, this role is pivotal for the...

This gives the exact same results as Jonathan's but only reads the near and next term data tables once each.

SELECT FP.UNDERLYING_SYMBOL,
   ...

This gives the exact same results as Jonathan's but only reads the near and next term data tables once each.

SELECT FP.UNDERLYING_SYMBOL,
     ...

Alternatively:

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

• This reply was modified 1 years, 10 months ago by Jonathan AC Roberts.
• This reply was modified 1 years, 10 months 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...