Hi mcx5000,

I'm sorry to bug again, I'm in a bind again, can you kindly help some more please?

My client finally had the chance to test this further on their actual...

Yep, that did it 🙂

You guys ROCK !!

Thank you Sir..

Hi mcx5000,

This is great, the results are looking great, thank you very much everyone 🙂

One thing I noticed was that if I add hours into Sunday that starts a new...

Hi Thava,

Thank you for your post, I will attempt to be more clear as to what is the required output. This client has a Weekly payroll (Mon - Sun), they...

Hi Jeff,

The output requirements are still the same, which is weekly output, I think for daily output you are referring to is what I posted for Sean when I was...

Hi Sean and MCX5000,

You guys are awesome, thank you for the queries, this is very helpful and timely especially for the crunch time that I'm in.

I ran the query...

Hi Sean,

Thank you for your reply, I've been out sick for the last few days, I have to deliver the report by Wednesday but sadly I lost 4 days due...

Hi Sean,

I know it's confusing, I will attempt to explain this as detailed as possible, so on daily basis up to 8 hours are going into REG hours bucket, any...

Hi Luis,

Sorry about the confusion and stupid question 🙂

Was doing too many things at the same time and obviously not thinking straight, everything is working great, thank you once again...

Hi Luis,

This is great!!

Would you kindly tell me how do I use my table in the following query?

My table already has data and the table is as follows:

CREATE TABLE TempSSProf_CustData

(PERSON...

Hi Luis,

I just saw your reply, thank you very much for such a quick reply.

I will try your code and I will let you know how it comes out.

Thank you...

Hi Guys,

I was able to get it done this way, not sure if this is most effective way though so please if you have a better solution please do let...

Hi Keith,

You have done it, simple and awesome 🙂

Thank you very much,

Best Regards,

Oops sorry.

Wonderful !!

You are awesome Dwaine 🙂

Thank you,