https://www.brentozar.com/pastetheplan/?id=H1rMn9evM

SteveMalcolm · February 13, 2018, 5:39pm

The second nested loop is warning that there is no join predicate. I'm still new to this so I'm confused. Is that because I am using a CTE to determine the values for two of the attributes? This presentation table is used in more that a few reports, and I don't want to create a second one for this very unique one.

Sometimes I feel like the Scarecrow and sometime like the Tin Man, but never the Lion.
Thanks,
SM

gbritton · February 14, 2018, 3:24pm

I think you may be seeing nested loops since the estimated row counts are small. The CTE is not a factor, it's just another way of writing a sub query, in your case.