Group by date with a SUM - Can't think!!

[Horace]

Thanks Guys for the help.

Gandolf, your code kept throwing this error at me....

ERROR at line 1:
ORA-12801: error signaled in parallel query server P019
ORA-01481: invalid number format model

Dave,

Both your scripts worked a treat, but I prefer the look of the first one, no noticable difference in query performance between the two.

Cheers!!