Rolling 4 Weeks Total

[luvmy2kids]

I am working on a report that I would like to capture totals going back 4 weeks?

For instance, I can easily capture this week's total because I can write something like this:

sum(isnull(e.AllTCHours, 0))
where weekending = '2009-8-29'...

How can I get a sum going back for the entire month of August which woud capture weekend '2009-8-22', '2009-8-15' etc... without having to hardcode it in.

Thanks for all help!!!!

 

[markros]

DateAdd function allows to use week as a parameter. See BOL for details.

 

[luvmy2kids]

Thanks for the reference!