intente con esto,
Código SQL:
Ver originalSELECT *
FROM EVENTS WHERE event_type = 270 AND
eventdate >= DateAdd(YEAR,DateDiff(YEAR,0,Getdate())-1,0)
GROUP BY identity_id,DATEADD(DAY,6,eventdate)
pero me sale este error
Cita: Column 'BH_EVENTS.event_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.