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 seconds for the entire string, so I am playing without the
> RIGHT() modifier right now. Maybe making a table with the status's on
> separate rows and then querying against that to make the single line??
>

Changes to what? Did i miss the post where you included the entire
SELECT statement?

(please don't top-post)

brian