RE: MS-SQL Group by Week

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

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

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