Hi Scott,

This works beautifully on my own system however I'm afraid to implement this on my client's Prod system unless I can back this up with enough knowledge about this...

Hi Scott,

Thank you for replying.

I'm getting an Invalid Object Name for dbo.DelimitedSplit8k, did I miss an step?

Thank you Sir !

DS

Hi Marco,

It works exactly how I want it but only when I have one employee's data as provided in the sample file.

When I include more employees in the table it...

Hi Scott,

This looks pretty close but missing right amount for second row of Reg in Week 2.

This client is driving me nuts, I've tried the following SQL (using Steven's query)...

Hello Scott,

Once again, really appreciate the help. I've been working on it from my end by using different methods using my limited knowledge but no luck.

No one else has provided...

Hi Scott,

I really appreciate your time and help and totally understand that you doing this to help others.

I had provided the data in previous post (shared below).

If I can understand...

Hi Scott,

Would you be able to help out again with the latest and hopefully last change request that I posted earlier?

I've been trying but not able to get the desired...

Hi Scott,

Man, you are a whiz and when I grow up I wanna be like you 🙂

Just kidding, I'm sure I'm older than you 🙂

This is exactly what I was...

Hello Friends,

So more logic changes requested by the client.

Similar query but luckily we now have a week indicator with extra columns and new paycodes that should be left out of...

Hi Scott,

This is awesome, I will test run this solution in the morning. Big Thank you again !

I wanted to ask if it is easy enough to drop the data...

Hi Scott,

Yes sir ! This one works like a charm.

You made an excellent point about multiple weeks and I thought about it as this could happen in my example since...

Thank you Scott for the help, this was very close but when I ran it, I got 8 hours of SICK twice for example # 1.

Thanks again !

DS

Hi Steve,

This is just what I was looking for, man, you are awesome !

You are right for 3rd example, the math was off but at the end of the day...

Hi Jeffrey,

Wow, this is crazy awesome.

Exactly what I was looking for 🙂

Thank you for saving the day for me !

Take care and God Bless.

DS