Re: strange select/join/group by with rollup issue....

2012-02-08 Thread Andy Wallace
Thanks, it seems to be working now. I just discovered "WITH ROLLUP". It made me very happy on this project... On 2/8/12 2:54 AM, Arthur Fuller wrote: I'm not sure your method isn't working, but try changing changing the "to date" part to "< '2012-02-08' " and see what you get. HTH, Arthur

Re: strange select/join/group by with rollup issue....

2012-02-08 Thread Arthur Fuller
I'm not sure your method isn't working, but try changing changing the "to date" part to "< '2012-02-08' " and see what you get. HTH, Arthur