SQL Sum Daily Data Weekly
From: <trpost_at_gmail.com>
Date: Fri, 18 Jan 2008 13:03:44 -0800 (PST)
Message-ID: <1f52f332-27ce-4a06-8e06-2abdaf9897ee@q77g2000hsh.googlegroups.com>
Date: Fri, 18 Jan 2008 13:03:44 -0800 (PST)
Message-ID: <1f52f332-27ce-4a06-8e06-2abdaf9897ee@q77g2000hsh.googlegroups.com>
I am looking to pull weekly stats from daily data, but am not sure the
best way to accomplish this. I would provide a start date, and then I
am looking to pull the last 52 weeks of data based on a start date. So
if I choose 1/18/2008 then I would get summed daily data for 1/12/2008
- 1/18/2008, 1/5/2008-1/11/2008 ......etc(going back 52 weeks)...
The additional challenge is that my data is daily, but I want to sum all columns except REPORT_DATE to get weekly totals:
example table data:
REPORT_DATE STARTS CONTINUES TOTAL 12/31/2007 50 100 150 1/01/2008 30 100 180 1/02/2008 60 100 160 1/03/2008 40 100 140 1/04/2008 20 100 130 1/05/2008 10 100 110 1/06/2008 70 100 170 1/07/2008 90 100 190 1/08/2008 60 100 160 1/09/2008 55 100 155 1/10/2008 35 100 135 1/11/2008 65 100 165 1/12/2008 45 100 145 1/13/2008 25 100 125 1/14/2008 15 100 115 1/15/2008 75 100 175 1/16/2008 95 100 195 1/17/2008 65 100 165 1/18/2008 5 100 105 Sample expected results: WEEK_ENDING STARTS CONTINUES TOTAL 1/18/2008 325 700 1025 1/11/2008 385 700 1085...
Thanks Received on Fri Jan 18 2008 - 15:03:44 CST