My present solution approach, in Tableau, was predicated on joining primary data table, containing rows representing the submissions, to the result of the query I've been trying to develop...

It doesn't matter what you select...

Why is it difficult to incorporate it into your solution?

Not sure I quite understand what results you want but I think this might do:

DROP TABLE IF EXISTS #tmp2
CREATE TABLE [#tmp2] (
     ...

I would write it using EXISTS instead of INs. It's easier if you use table aliases.

Then look at increasing the performance by adding indexes.

CREATE PROCEDURE dbo.spTest
(
 ...

I tried it and they were about the...

In this case - yes. Because GROUP BY is applied to the output of the SELECT - making...

It explained where the performance improvement comes from.

If you want to see it - just rewrite...

This should speed the query up

IF OBJECT_ID('tempdb..#CTE','U') IS NULL
    DROP TABLE #CTE

SELECT *
  INTO #CTE
  FROM (SELECT Po.GlobalPnId ,
   ...

It explained where the performance improvement comes from.

If you want to see it - just rewrite any of...

• Sergiy wrote:

  The important points are these:

  • DISTINCT is pretty nasty beast. There is no excuse for lazy programming using it, even if "everyone does it".

I don't see...

• Sergiy wrote:

  The important points are these:

  • DISTINCT is pretty nasty beast. There is no excuse for lazy programming using it, even if "everyone does it".

I don't see why/how GROUP...

I would attempt to speed the query up with the use of temporary tables, try this for starters:

IF OBJECT_ID('tempdb..#BCMasterydaily', 'U') IS NOT NULL 
   ...

You will get better performance if you write 2 statements, an update followed by an insert (where not exists)

Performance Tip: The conditional behavior described for the MERGE statement works best when...

If you look at the message on the INSERT it says:

"The query had to wait 1164 seconds for MemoryGrant during execution"

That's nearly 20 minutes.

https://techcommunity.microsoft.com/t5/sql-server/understanding-sql-server-memory-grant/ba-p/383595

Try adding this to the end...