根据表内分数降序排列，显示用户名，大类，小类

 1 SET ANSI_NULLS ON
 2 GO
 3 SET QUOTED_IDENTIFIER ON
 4 GO
 5 
 6 CREATE PROCEDURE S_GetScoreRank
 7 @timestart datetime,
 8 @timeend datetime
 9 AS
10 BEGIN
11 select *
12     from(
13     SELECT
14      S_UserNum as u,
15      SUM (S_Score) as s,
16      S_BigClass as bc,
17      S_SmallClass as sc from S_Matter
18      where 
19      @timestart<=S_PlanStart
20      and @timeend>=S_PlanStart
21      group by S_UserNum,S_BigClass,S_SmallClass
22      )as c
23      order by s desc
24 END
25 GO

若要按本月的发生的事件进行查询时可以使用

Where DateDiff(mm,[Create on], GetDate()) = 0

上个月1 下个月-1

其他时间同上