Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Apr 18, 2011 04:34 PM|LINK
I have the following setup, but when you review the results, they arent ordered correctly. Since the date was converted to varchar, it puts the dates in numerical order.. instead of actual date order.. but if i switch the order by to this, it complains that
its not contained in aggregate function bla bla bla.. how can i truely order the results by date and still have my group by conditons.
ORDER BY EventRptDate DESC
GROUP BY NodeId,CONVERT(VARCHAR(10),EventRptDate, 101),FirmwareVersion,OverallHealth
ORDER BY CONVERT(VARCHAR(10),EventRptDate, 101) DESC