Weston, Craig (OFT) wrote:
There were 2 changes -
First was IF(`status` = 'WIP',SUM(time_to_sec(RIGHT(`CLOCK_TIME`),8)),0)
AS 'WIP' ( I addded the "RIGHT" limit on the string)
And second was grouping by KEY,STATUS
Further experimentation makes it appear that I am getting the right
number of
y the sender immediately by reply e-mail and delete
the e-mail from your system.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 19, 2007 12:02 PM
To: mysql@lists.mysql.com
Subject: Re: [MYSQL]time of elapsed time
Weston, Craig (OFT) wrote:
&
Weston, Craig (OFT) wrote:
Baron, thank you for your response.
I did get a different result for the query:
18184639,12544976,0,0,0,0,0,0,0,0,0,0,0,0
But it still is "all" the data for the ticket in the row.
If I group by the ticket (key) number and the status, I get one line per
status with t
ail from your system.
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Friday, October 19, 2007 8:53 AM
To: Weston, Craig (OFT)
Cc: mysql@lists.mysql.com
Subject: Re: [MYSQL]time of elapsed time
Hi Craig,
Weston, Craig (OFT) wrote:
> Hello everyone.
>
> Onc
Hi Craig,
Weston, Craig (OFT) wrote:
Hello everyone.
Once again, I am jousting at the windmill of time and date formulae
within MYSQL. I seek to create a cross-tab or pivot table of the SUM of
all times with a specific category, on a per-ticket basis. I have
everything working except the math
