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:240870 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
