Thanks, I found a way to do it. Just had to add a field to the Table to hold the WeekNumber and the GROUP by WEEKNUM ;-)
Thanks! -----Original Message----- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 17, 2006 10:18 PM To: CF-Talk Subject: RE: MS-SQL Group by Week Check out this thread: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6228 M!ke -----Original Message----- From: Coldfusion [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 17, 2006 9:07 PM To: CF-Talk Subject: MS-SQL Group by Week Does anyone know if it is possible via Query to group results by Week when the field actually contains a full date? I have a query where I have to pull all data and the SUM of a field which all should be grouped by Week such as: Week 1 (01/01/2006 - 01/07/2006) John Smith Project 5: 15hrs Project 6: 10hrs Week 2 (01/08/2006 - 01/15/2006) John Smith Project 5: 12hrs Project 6: 19hrs ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240871 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54