I've got the following query:
datename(month,log_date) + ' ' + datename(year,log_date) as CalcDate,
When I try to run it however, I get:
Msg 207, Level 16, State 1, Line 4
Invalid column name 'CalcDate'.
How am I able to group by CalcDate to get my desired result?