assigning variables

homer.favenir · #1 (**permalink**) 06-11-08, 05:59

hi to all,
how can i assign variables in a regex?
e.g.

Code:

sum(coding_log.break_hours) as 'total break',

and use it to another regex.
thanks

homer.favenir · #2 (**permalink**) 06-13-08, 06:01

Code:

SUM(CASE WHEN coding_log.time_end > '16:00' THEN coding_log.break_hours ELSE 0 END) as 'Total OT Break',

-- total ot idle work related
format(time_to_sec(SUM(CASE WHEN coding_log.time_end > '16:00' && coding_log.adjustment = 'Idle (work related)'
        THEN coding_log.adjustment_time ELSE 0 END))/3600,2)
        as 'Total OT Idle (work related)',

-- total ot idle personal
format(time_to_sec(SUM(CASE WHEN coding_log.time_end > '16:00' && coding_log.adjustment = 'Idle (personal)'
        THEN coding_log.adjustment_time ELSE 0 END))/3600,2)
        as 'Total OT Idle (personal)',

-- total ot meeting
format(time_to_sec(SUM(CASE WHEN coding_log.time_end > '16:00' && coding_log.adjustment = 'meeting'
        THEN coding_log.adjustment_time ELSE 0 END))/3600,2)
        as 'Total OT Meeting',

-- total ot orientation
format(time_to_sec(SUM(CASE WHEN coding_log.time_end > '16:00' && coding_log.adjustment = 'orientation'
        THEN coding_log.adjustment_time ELSE 0 END))/3600,2)
        as 'Total OT Orientation',

i like to add 'Total OT Break', 'Total OT Idle (work related)', 'Total OT Idle (personal)'.

any advice, please.

thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech