--- Mike Franks <[EMAIL PROTECTED]> wrote:
>
> Hi Bob,
>
> If all you truly want is the number of items entered, by day, for a
> given
> date range, you can do this in a single query. I run several Oracle
> reports each month that do exactly this.
>
> select to_char(cust_adddate, 'yy/mm/dd'), count(*)
> from customer
> where cust_adddate
> between to_date(&start_mmddyyyy,'MMDDYYYY')
> and to_date(&end_mmddyyyy)
> group by to_char(cust_adddate,'yy/mm/dd')
Thanks, Mike! That's a slightly more elegant solution than the one I
eventually stumbled upon late last night. In the interest of keeping
the scripts clean, I'm implementing yours instead.
Appreciate it!
-Bob
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/HKFolB/TM
--------------------------------------------------------------------~->
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
