Friend,
I learned that 8 + 4 = 12. Maybe you just missed that class ... :D
Before talk, think. ;)
On Thu, 26 Jul 2001 12:31:23 -0700 [EMAIL PROTECTED] wrote:
| 8.00user1
| 14.00 user2
| 160.00 user 3
|
| Now, where I went to school, this adds up to 184!
Cya
Antonio
[
riday, July 27, 2001 10:37 AM
Subject: Re: possible bug in sum() function
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
>
> the query was:
>
> select sum(worktime),user from timecard where tcacct=project group by user;
>
> the answer was:
>
> 8.
Bruce Ferrell writes:
> I'm replying to the list because I got so many of these back:
>
>
>
> Ya know gang... some days it just doesn't pay to get outta bed.
>
> Yes, indeed, this is the exact reason my wife doesn't let me do arithmatic :)
>
> Sorry and to the guy who replied with no spam
Hehehehe.
- Original Message -
From: "Geoff Blake" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 11:37 AM
Subject: Re: possible bug in sum() function
> On Thu, 26 Jul 2001 [EMAIL PROTECTED]
I'm replying to the list because I got so many of these back:
Ya know gang... some days it just doesn't pay to get outta bed.
Yes, indeed, this is the exact reason my wife doesn't let me do arithmatic :)
Sorry and to the guy who replied with no spam please? what can I say, my face is ver
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
>
> the query was:
>
> select sum(worktime),user from timecard where tcacct=project group by user;
>
> the answer was:
>
> 8.00user1
> 14.00 user2
> 160.00 user 3
>
> Now, where I went to school, this adds up to 184!
>
> Suggestions?
>
T
[EMAIL PROTECTED] writes:
> We keep a timecard database and I was just asked how much time had been charged to a
>particular project code. No problem says I and did the following:
>
> select sum(worktime) from timecard where tcacct=project;
>
> The answer came back 182. Then I was asked who h
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
> We keep a timecard database and I was just asked how much time had been charged to a
>particular project code. No problem says I and did the following:
> select sum(worktime) from timecard where tcacct=project;
> The answer came back 182. Then I wa
[EMAIL PROTECTED] wrote:
> We keep a timecard database and I was just asked how much time had been charged to a
>particular project code. No problem says I and did the following:
>
> select sum(worktime) from timecard where tcacct=project;
>
> The answer came back 182. Then I was asked who
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 5:31 AM
Subject: possible bug in sum() function
> select sum(worktime) from timecard where tcacct=project;
>
> The answer came back 182. Then I was asked who had spen
We keep a timecard database and I was just asked how much time had been charged to a
particular project code. No problem says I and did the following:
select sum(worktime) from timecard where tcacct=project;
The answer came back 182. Then I was asked who had spent time on the project.
the qu
11 matches
Mail list logo