Please review my prior question, which as been answered and closed:
Now, I just want to add back in one more column... the original LL.Label_Text, so that I can see this value in the returned results. I tried adding it in the select statement, but I get this error: Msg 8120, Level 16, State 1, Line 1
T' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
When I add it to the Group By clause, I get all the results returned from my table (306) rather than my filtered data.