You might consider looking into using the DATAPART function and summing and averaging on the WEEK datepart.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples