>
>Both need totals, no matter if it is weekly. My week is based on Sunday first day. I use datepart(wk, date), it use client's machine?

OK, sorry for being a bit dense, but I want to make sure I understand what results are needed.

Let's say the first result set has counts summarized for every day in September. So the first result set would have 30 rows.

Would the 2nd result set look like this?

WeekEnding             #Quotes    #column2     #column3         #column4
9/5/2015               100           200               300              400
9/12/2015             200           300               400              500
9/19/2015             300           400               500              600
9/26/2015             400           500               600              700
10/3/2015             500           600               700              800
NULL                    1500         2000            2500             3000

Is that would you want the 2nd result to look like? One row per week, plus a grand total?