怎样以周为单位Group by ?

[joyfire]

新手，初级问题可能很简单，大虾指点
我的表MyTable里有MY_ID（主键）,People_ID和Insert_Time字段
Insert_Time字段是smalldatetime类型的

现在要以周为单位统计加入的记录数
我SQL比较弱，只知道如何得到年月日然后group by，不知道星期几如何计算，
请大虾指点

[paoluo]

如果是以MY_ID为统计数据的话
Select Count(MY_ID),DatePart(dw,Insert_Time) from MyTable Group By DatePart(dw,Insert_Time)

[FCU]

创建一个作业

[paoluo]

Select
Count(MY_ID) As 记录数,
(Case DatePart(dw,Insert_Time) When 2 Then N'星期一' When 3 Then N'星期二' When 4 Then N'星期三' When 5 Then N'星期四' When 6 Then N'星期五' When 7 Then N'星期六' When 1 Then N'星期天' End )
from MyTable Group By DatePart(dw,Insert_Time)

[zjcxc]

--一周的第一天为星期一计算

Select Count(MY_ID) As 记录数,周=DatePart(dw,Insert_Time-1)
from MyTable
Group By DatePart(dw,Insert_Time-1)

[zhangzs8896]

Group By DatePart(dw,Insert_Time)

[xluzhong]

SET DATEFIRST 1
Select DatePart(dw,Insert_Time) as [weekday],
Count(*) as [count]
from MyTable
Group By DatePart(dw,Insert_Time)