I assume that "from #temp t" is due to you using a temp table to run the cte query and that it would not be a part of a final...

I have included a snippet of my dataset. Unfortunately, I would need to try and find the specific things I have tried as I blew them away when they...