Hi Eirikur Eiriksson,

You are the man 🙂

I really appreciate your help for the second time 🙂

Can you please guide me to an article or a site where I can further...

Yes, this is it.

Thank you so much sir !!

You are a life saver.. God bless..

Hi Luis,

This is exactly what I needed..

Thank you Sir, you are awesome.

I will study up the article to referred me to and once again I really appreciate the help.

Have a...

Hi Lynn,

You are right, I'm adding a new row of data for Regular2.

Regards,

Zulf

Hi Evil Kraig F,

The way this works at the client site is that employees daily worked hours are recorded as Pay Type (Regular) carrying lets say 8 hours each day...

Hi Cadavre,

Thank you so much for ALL your help and time in helping me with this issue, God bless you..

I left out a BIG piece of information that the client...

Hi Cadavre,

I had a feeling that I screwed up somewhere with my post.

The pay Data and Reset Data values comes from different tables customer's database, I could use datetime data...

Yep, works like a charm 🙂

Thank you very much Sir !!

Hi There,

Actually the client changed the requirements, if it's the first Saturday between the selected dates then in CODEID column we would have a value of 450, for the second...

Awesome, this is perfect.

Thank you very much everyone for all the help 🙂

Hi There,

Oh man, I wish this client had SQL Server 2012, they are using SQL 2005 🙁

Thanks for the help though 🙂

Take care,

Hi Koen Verbeeck,

So that's all I needed :), so I guess I had the rest setup okay.

Good deal thanks.

Take care.

Hi Thava,

Wow, this is it, working like a charm !!

Brilliant work, thank you very much and god bless you..

Hi mcx5000,

Here is the breakdown and allocation of the hours for REG, DAILY_OT and WEEKLY_OT.

**The DAILY_OT hours do not count towards the REG 40 hours in the week goal**

1. 01/06/2014...

Hi mcx5000,

I totally agree with you, and I'm frustrated as well, the requirements are still the same, meaning up to 8 hours daily hours goes into REG bucket, over 8...