>>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?

Absolutely, it's right.