Hi Luis,

I used the CAST solution, I will study this in more detail so at the moment I don't have any questions.

Best Regards,

ZA

Hi Luis,

Just wanted to let you know that your solution worked like a charm so thank you thank you.

Best Regards,

Zulf

Hi Luis,

This is AWESOME..

Thank you very much.

I will give this a go when I next log into my clients system.

Thank you again.

🙂

Sounds fair.

I wish I can be as good as you someday however in the mean time I will keep on learning and try to decipher your codes to see if...

Woohoo, I just went from Grasshopper to a Rookie 🙂

I did change the 9 to 3 and it's working beautifully 🙂

How about if I want to see the 3...

Hi Dwaine,

First of all your last script worked wonderfully so thank you again 🙂

Now, not changing the requirements and trust me I tried to follow your last script but it's...

Hi Dwaine,

I would like to apologize and say that I didn't mean to say it the way it came out, I know you guys are here to help everyone and...

Hi Dwaine,

Once again appreciate your help and kindness.

I ran the query and added two new rows of data for employee (1125) and got weird results.

Also, I know you said...

Hi Dwaine,

You are amazing, how do you come with such codes? 🙂

When cumulative Double total is less than 9 then you are right hours stay as they are.

Can I ask...

Agree with both of you 🙂

So you think it's possible to add the last Total column?

Thank you again guys.

Hi Dwain,

That's what happen when you work on something for too long :-), you are a genius Sir, you solved one of my problems but now me being a moron...

Hi Dwain,

Actually I should be sorry for confusing the matter 🙂

Hopefully my latest post explains a little better but let me try to answer your questions, also thank you for...

Hi Guys,

I'm sorry about the confusion, I guess I should take it step by step, first I need to add a total column as the last column so then I...

Sorry I forgot to add the sample data.

WITH SampleData (PERSON, [DATE], [HOURS], PAYCODE, TOTAL) AS

(

SELECT 1125,'27/01/2014',0.25,'Double',0.25

UNION ALL SELECT 1125,'27/01/2014',0.50,'Double',0.50

...

Hi Dwain,

From the sample data I need to check if the Double Paycode has reached 9 hours, once it has, I use that date as the effective date with 9...