I uploaded your picture to ChatGPT 4 and asked it to: "Write a SQL Server create table (table name: XXXRE60P) and insert script for this, make sure you include all...

;WITH CTE AS
(
    SELECT DISTINCT
           RBDCTL,
        ...

Also try removing the last character from the string.

$dateTimeString = (Get-Date).ToString('yyyy-MM-dd HH:mm:ss')
$dateTimeString = $dateTimeString.Substring(0, $dateTimeString.Length - 1)

Not sure if this will be any faster, you might have to look at putting indexes on the table if it is not:

;with cte as
(
...

Not sure if this will be any faster, you might have to look at putting indexes on the table if it is not:

;with cte as
(
  ...

I think I fixed the issue.  I added t_date to the partition part and now I am getting the correct number of records.  The query is super slow though. ...

SET @sql_template = N'SELECT MAX([$column$]) AS [$column$],...

concat_ws applies to SQL Server 2017 (14.x) and later

If you haven't got it on your database then use this instead:

concat(c.TABLE_CATALOG, '.', c.TABLE_SCHEMA, '.', c.TABLE_NAME)

DECLARE @TableString AS nvarchar(MAX)
DECLARE @SqlString as nvarchar(MAX) = ''
DECLARE MyCursor...

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 7 months, 3 weeks 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,
     ...