[RESOLVED] Count Absent for a Month, Quartely, Weekly, etc using Query

[erickwidya]

let say i have records like this (see the picture to make it simpler)

and the following question:
1. calculate the maximum Absent in a row for Employee A for a Week(Sunday to Saturday) in a Month?
2. calculate the Absent for Employee A for a Month?
3. calculate the Absent for Employee A for a Year?

the answer for it are:
1. Sep 2007, Week 3, 3 in a row
Sep 2007, Week 5, 2 in a row
Oct 2007, Week 2, 2 in a row
2. Sep 2007, 6 Absent
Oct 2007, 4 Absent
3. for the ilustrated it would be Total Absent = 10

can Query do something like that? using what? pls give some insight

PS: i'm using SQL Server 2000

thanks