Let me get this straight, you want a report to summarize the number of
installs by date and client. So client 1 ran 3 installs on 6/1 and 2
installs on 6/2.
I believe you simply need to group by hostname, and then date and then
use an aggregate function (count()) to add up the records in between
[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
and companyid in (select distinct companyid
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: Friday, June 03, 2005 10:20 AM
To: CF-Talk
Subject: SQL Help Please
I've
I've got a query that I just can't get right.
select *
From companies
where companyhide = 0
and companyid = (select distinct companyid
From releases where date_entered = DATE_SUB(curdate
(),INTERVAL 8 day) and date_entered = DATE_SUB
and companyid in (select distinct companyid
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
That's it! I forget about in. I knew it was simple.
Thanks!
-jeff
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent:
Maybe I'm misunderstanding what you are trying to do, but try this
Select count(Referer) as refcount
From myTable
Where Referer = #myUserID#
Cutter
Dave Phillips wrote:
Hi guys,
I hope this isn't too far off topic, but I'm stuck on an SQL issue and
really need some help.
I have a
94% of it for you? -
http://honor.94percent.com
_
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 8:31 PM
To: CF-Talk
Subject: Re: SQL Help Please?
Maybe I'm misunderstanding what you are trying to do, but try this
Select count(Referer) as refcount
From myTable
This is what you need ...
SELECT DISTINCT(referer), COUNT(referer)
FROM users
GROUP BY referer
-- Jeff
_
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 8:37 PM
To: CF-Talk
Subject: RE: SQL Help Please?
Unfortunately, that will only give me the number
% of it for you? -
http://honor.94percent.com
_
From: Jeff Chastain [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 8:39 PM
To: CF-Talk
Subject: RE: SQL Help Please?
This is what you need ...
SELECT DISTINCT(referer), COUNT(referer)
FROM users
GROUP BY referer
-- Jeff
_
From: Dave Phillips
PROTECTED]]
Sent: Thursday, March 14, 2002 11:06 AM
To: CF-Talk
Subject: Re: SQL help please
try
select employeeid, startdate, enddate, count(*), paycatid
from X
group by employeeid, startdate, enddate, paycatid
WWW:http://www.euservices.com
__
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 6:10 PM
To: CF-Talk
Subject: Re: SQL help please
Nope, that doesn't work
Yeah, I ended up using a cursor to do it. Thanks Bill.
-Original Message-
From: Bill Grover [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 6:01 AM
To: CF-Talk
Subject: RE: SQL help please
I'm not sure you can do it with a simple select statement. If I understand
what you
:
03/13/02 Subject: Re: SQL help please
04:51 PM
Please
Anyone?
Bueller? Bueller?
- Original Message -
From: [EMAIL PROTECTED]
Date: Wednesday, March 13, 2002 2:51 pm
Subject: SQL help please
Brain not working Must help...
Here's my data set:
employeeid startdate enddate paycatid
--- --- --- ---
select ... count(paycatid) as samepaycatid group by paycatid
laszlo
[EMAIL PROTECTED] wrote:
Anyone?
Bueller? Bueller?
- Original Message -
From: [EMAIL PROTECTED]
Date: Wednesday, March 13, 2002 2:51 pm
Subject: SQL help please
Brain not working Must help...
Nope, that doesn't work.
- Original Message -
From: laszlo [EMAIL PROTECTED]
Date: Wednesday, March 13, 2002 4:06 pm
Subject: Re: SQL help please
select ... count(paycatid) as samepaycatid group by paycatid
laszlo
[EMAIL PROTECTED] wrote:
Anyone?
Bueller? Bueller
: SQL help please
Nope, that doesn't work.
- Original Message -
From: laszlo [EMAIL PROTECTED]
Date: Wednesday, March 13, 2002 4:06 pm
Subject: Re: SQL help please
select ... count(paycatid) as samepaycatid group by paycatid
laszlo
[EMAIL PROTECTED] wrote:
Anyone
I've built an application for a Fire/Rescue service to log their calls,
meeting attendance, etc. (geared to small, volunteer agencies). One of the
things that's very important for them is a sum of the hours spent
on calls.
Each call record has a uniquely generated call number that is the
Philip,
Thanks for the help. Unfortunately, that didn't do the trick. The query
returns a -2. I've put in test records to this point, so I know that the
return should be 22.
Any other ideas?
Thanks,
Scott
Scott Brader
Prairie Software Development LLC
101 East Sadd Street
PO Box 235
North
Philip,
Upon further testing, your suggestion does work fine, however, I'm getting
the error whenever the times are on two different days; dispatch time was
23:25 and return to quarters time was 02:15. Will I have to change it from
short time format to a different date/time format?
Thanks,
Scott
, 2001 1:42 PM
To: CF-Talk
Subject: RE: SQL Help, Please
Philip,
Thanks for the help. Unfortunately, that didn't do the trick. The query
returns a -2. I've put in test records to this point, so I know that the
return should be 22.
Any other ideas?
Thanks,
Scott
Mobile: 262.490.1376
http://www.prairiesoftdev.com
Amateurs practice until they get it right,
Experts practice until they can't get it wrong.
-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 7:51 AM
To: CF-Talk
Subject: RE: SQL Help, Please
22 matches
Mail list logo