weekly,halfyearly,quarterly reprts from sql database

Jul 2 2009 3:36 AM

how can i take weekly,quarterly,halfyearly reports....
where table contans

name amt date
a 100 1/1/2008