Viewing 15 posts - 1 through 15 (of 100 total)
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...
August 31, 2021 at 6:12 pm
Thank you for replying.
I'm getting an Invalid Object Name for dbo.DelimitedSplit8k, did I miss an step?
Thank you Sir !
August 31, 2021 at 3:34 pm
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...
June 5, 2021 at 8:04 am
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)...
May 11, 2021 at 7:42 am
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...
May 10, 2021 at 5:53 pm
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...
May 9, 2021 at 8:12 am
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...
May 8, 2021 at 9:06 am
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...
May 7, 2021 at 8:25 am
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...
May 7, 2021 at 8:22 am
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...
May 7, 2021 at 6:43 am
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...
May 5, 2021 at 3:43 pm
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 !
May 3, 2021 at 8:35 am
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...
May 3, 2021 at 8:33 am
Wow, this is crazy awesome.
Exactly what I was looking for 🙂
Thank you for saving the day for me !
Take care and God Bless.
January 26, 2021 at 10:30 pm
August 24, 2017 at 6:08 pm