Hi, I'm using a CASE statement in the SELECT clause of my query, and I'm getting the following error when I try to execute it:
Msg 8120, Level 16, State 1, Line 95
Column 'BLINDS_EDW.dbo.VW_EXACTTARGET_JOB_MASTER.EmailName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
This is a pic of the error:
This is my query:
I added the column name, "EmailType" into the group by clause and I'm still getting the error. Any help is resolving this error would be greatly appreciated.