The Red...

Yeah, I can't figure this out. But it is the case that if I simply insert the result of the nested query into a temp table first, then select from...

Yeah, I know its a lot. My main question is just what would cause performance to degrade so much just going from:

SELECT

x,

y,

z

FROM

...

Here is a plan where its just the query encapsulated in SELECT * FROM ()

Remember, if I run just the part inside the outer nesting it runs in under 5...

Actually I did have it joined to a different table at first, but I removed that thinking that the join was the problem.

When I do an estimated execution plan,...

It's good, but it still doesn't resolve the biggest problem with SQL's PIVOT functionality (which is no fault of yours), which is that there is no way to create a...