Thanks Dishdy. I see now that the data actually doesnt exist that way, but the way I created my solution, it ended up that way for me...back to the drawing board...

Was there something in the rules that states we are supposed to merge together sequential (yet separate)time punches together if they are for the same job and technician? The difference in mine would be the 6:45 to 9:30, then 9:30 to 11:43 punch for tech

I submitted a solution that starts with "WITH", but not ";WITH"...I assume that this will be ok...since i either had to break the "a single query that starts with "WITH" or "SELECT" rule or risk the query throwing an error if you didnt add and ";" to the s