Hi Sergiy,

Thank you for the quick help.

I'm not sure what to use in the {Matching Criteria} section of each query, here is the Item # 1 query.

Once I have it...

Hi pietlinden,

I kept calling you Ten Centuries so I my apologies LOL..

Your solution worked sir so thank you VERY MUCH for your kind and quick help !!

Regards,

D

Hi Ten Centuries,

I removed the ORDER BY clause and it gave me the results I was looking for.

Thank you,

D

Hi Ten Centuries,

Thank you for the quick reply, I ran the query and I get the following error:

Msg 102, Level 15, State 1, Line 11

Incorrect syntax near 'order'.

Regards,

D

Hi sgmunson,

Sorry for the late reply as I have been traveling and finally came back home to work on this again.

So an excellent question and the answer is that the...

Hi Eirikur Eiriksson,

Yes, this is what I needed.

You are awesome and thank you very much for the quick help.

Regards,

DZA

Hi Wayne,

It's me again 🙂

As last time the customer changed some minor requirements again, now they want the IN_PUNCH to be the first in punch of the day and the...

Hi Wayne,

Yes, exactly what the desired results were required..

Awesome work 🙂

Thank you, thank you..

God bless,

DZA

Hi Guys,

So Wayne's solution worked perfectly until they changed the requirements a bit, now IN_PUNCH and OUT_PUNCH columns should be blank if there are only ABSNET_HRS in a day, when...

Hi Wayne,

So the client came back with more changes to the script 🙁

What they want is that if the WORK_PAY is NULL and the WORK_HRS are 0:00 then they want...

Hi Wayne,

Yes it surely did.

I sincerely appreciate your urgent help on this so thank you again,

God Bless !!

Hi Wayne,

You are right, there is a discrepancy there for the 07/27/2015 for PERSON it should be 08:00 to 10:00 instead of 12:00 to 12:00.

Secondly, we can get rid of...

Hi Wayne,

Thank you looking into this for me, I could and have removed the SHIFTS as I think this would just create more confusion, I can always add it back...

Hi Wayne,

I can remove the SHIFTS_LABEL column as it will confuse the matter more, I can always add it back on later once the main query is outputting the desired...

Hi Sean,

They are not all varchar, STARTDATE and ENDDATE are datetime but in my sample data I used the 'CONERT(VARCHAR(10), STARTDATE, 101) method to display the results cleaner.

They (the client)...