[EMAIL PROTECTED] wrote:
> HostName, iDate, Package
> client1, 2007-06-01, Update1
> client1, 2007-06-01, Update2
> client1, 2007-06-01, Update3
> client1, 2007-06-02, Update5
> client1, 2007-06-02, NewApp
> client2, 2007-06-01, Update1
> client2, 2007-06-01, Update2
> client2, 2007-06-01, Update3
> client2, 2007-06-02, Update5
> client2, 2007-06-02, NewApp
>
> What I want is a report/summary like result that looks like this
>
> HostName, iDate, Installs
> client1, 2007-06-01, 3
> client1, 2007-06-02, 2
> client2, 2007-06-01, 3
> client2, 2007-06-02, 2
SELECT
HostName,
iDate,
COUNT(Package)
FROM
installs
GROUP BY
HostName,
iDate
ORDER BY
HostName,
iDate
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282372
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
