SQL Group By Problem
I have a table that has 3 cols namely points, project_id and creation_date. every time points are assigned a new record has been made, for example.

points = 20 project_id = 441 creation_date = 04/02/2011 -> Is one record <br>
points = 10 project_id = 600 creation_date = 04/02/2011 -> Is another record <br>
points = 5 project_id = 441 creation_dae = 06/02/2011 -> Is final record

(creation_date is the date on which record is entered and it is achieved by setting the default value to GETDATE())

now the problem is I want to get MAX points grouped by project_id but I also want creation_date to appear with it so I can use it for another purpose, if creation date is repeating its ok and I cannot group by creation_date because if I do so it will skip the points of project with id 600 and its wrong because id 600 is a different project and its only max points are 10 so it should be listed and its only possible if I do the grouping using project_id but then how should I also list creation_date

So far I am using this query to get MAX points of each project

SELECT     MAX(points) AS points, project_id
FROM         LogiCpsLogs AS LCL
WHERE     (writer_id = @writer_id) AND (DATENAME(mm, GETDATE()) = DATENAME(mm, creation_date)) AND (points <> 0)
GROUP BY project_id

This query brings the result of current month only but I would like to list creation_date as well. Please help.
SQL Group By Problem
===

I have a table that has 3 cols namely points, project_id and creation_date. every time points are assigned a new record has been made, for example.

points = 20 project_id = 441 creation_date = 04/02/2011 -> Is one record <br>
points = 10 project_id = 600 creation_date = 04/02/2011 -> Is another record <br>
points = 5 project_id = 441 creation_dae = 06/02/2011 -> Is final record

(creation_date is the date on which record is entered and it is achieved by setting the default value to GETDATE())

now the problem is I want to get MAX points grouped by project_id but I also want creation_date to appear with it so I can use it for another purpose, if creation date is repeating its ok and I cannot group by creation_date because if I do so it will skip the points of project with id 600 and its wrong because id 600 is a different project and its only max points are 10 so it should be listed and its only possible if I do the grouping using project_id but then how should I also list creation_date

So far I am using this query to get MAX points of each project

SELECT     MAX(points) AS points, project_id
FROM         LogiCpsLogs AS LCL
WHERE     (writer_id = @writer_id) AND (DATENAME(mm, GETDATE()) = DATENAME(mm, creation_date)) AND (points <> 0)
GROUP BY project_id

This query brings the result of current month only but I would like to list creation_date as well. Please help.