Home Forums SQL Server 2005 SQL Server 2005 General Discussion Date field in Select & Group by RE: Date field in Select & Group by
Oliiii
SSCertifiable
Points: 5328
More actions
October 12, 2010 at 7:05 am
#1235483
Well if you include the start date in the group by, it'll output a row per different start date.
So it's working the way it's supposed to work ...
To resolve your problem, remove start date from the group by and do a max(startdate) in your select.