Sorry to bump this thread, but I've run into a minor issue.

When I re-open the view that uses this code, this part...

WITH CTE AS
(

Is GONE, which causes...

• This reply was modified 7 months, 1 week ago by  tsobiech.

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

WITH CTE AS
(
    SELECT xp.RBDTYR
      ...

Try this, it is possibly faster:

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

187,450

I don't believe so, as I only have read-only access to the...

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

• This reply was modified 7 months, 2 weeks ago by  tsobiech.

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

Have you tried my solution?

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

• This reply was modified 7 months, 2 weeks ago by  tsobiech.

OK, try it as a basic aggregate

SELECT    RBDCTL
        , RBDTTC
      ...

• This reply was modified 7 months, 2 weeks ago by  tsobiech.

Ugh, such a stupid thing to overlook.  I don't do this every day so... my apologies.

• This reply was modified 7 months, 2 weeks ago by  tsobiech.

OK, try it as a basic aggregate

SELECT    RBDCTL
        , RBDTTC
      ...

• This reply was modified 7 months, 2 weeks ago by  tsobiech.
• This reply was modified 7 months, 2 weeks ago by  tsobiech.

...and how do I do that?  I don't mind taking the time, I just don't even know what step 1 is.

• This reply was modified 7 months, 2 weeks ago by  tsobiech.

I...

Try using a window function

SELECT    RBDCTL
        , RBDTTC
        ,...

• This reply was modified 7 months, 2 weeks ago by  tsobiech.

I'm using Excel 2010 - and...

exec Act32EITReport ?,?