Have you checked the SQL Server logs?

As someone who used temp table and had a lot of issues with it, I highly recommend start creating table into DB and use it.

TempDB is good only if...

Different users can be...

Different users can be...

This produces the exact same results as Jonathan's query with far fewer reads.

WITH CTE AS
(
    SELECT xp.RBDTYR
      ...

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

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

Have you tried my solution?

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

Have you tried my solution?

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

OK, try it as a basic aggregate

SELECT    RBDCTL
        , RBDTTC
     ...

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