On Thursday 24 April 2008 12:26:09 pm Gary Greenberg wrote:
> except that there is no entry for April 20th as there were no
> transactions at that day. I need a query to return me zero for that day.
> I.e. I need uninterrupted sequence of dates.
> I am beating my head at this problem for the whole day and did not make
> much of a progress. If someone has any idea how to resolve this problem,
> I'll appreciate a tip greatly.

Make a new list of just dates then join them both together.



--
Regards,

Michael Cole
LPIC-1



"The man who does not read good books has no advantage over the man who can't
read them. "
- Mark Twain

"It is our choices, Harry, that show what we truly are, far more than our
abilities."
— J. K. Rowling

"Wear the old coat and buy the new book."
— Austin Phelps

"I'm not a teacher: only a fellow traveler of whom you asked the way. I
pointed ahead – ahead of myself as well as you."
— George Bernard Shaw