Result same any suggestion..

Chris it worked.

Thank you..

Hi,

Data is given for also 10371 for which find below query results,

Hello chris,

Thanks for your feedback.Could you direct the reason for not computing OT correctly in event of multiple clock events ?

Many thanks in Advance.

Hi,

For Data Definition Language please refer my first page.

BR

Hi,

My issue is different. if you see where multiple clock ex: clock in1, clock out1,clock in2,clock out2, and see the OT which is not computing correctly since this has more...

Hi,

I need to display tomorrow date result also . could you guys guide me achieve the same .

Hello tes,

Thanks, with given condition i am unable to bring following result . could you guide pls.i am trying to bring group sum.

expected results.

Hello Chris,

Thanks , Glad to see more hit in our Question and Answer. Sorry if i ask more question . Is it possible i can ask many or do i...

Hello Chris, Thanks i did coding in ASP.NET itself.

By the way i am trying to bring query with the last clock_in where no clock_out for the same details ascending...

I am using ASP.NET . but i am unable bring total sum .

BR.

Hello Chris,

Thanks for your feedback.

With your query i am trying to bring two more column. One from database which is dutyhours and another one is OT which computed from (Dutyhours-hoursworked)....

Hello Chris,

I am having challenges with "Date" have got two SQL server (SQL 2005 & 2016).

Your code is rocking with SQL 2016 but in 2005 it throw error...

hello chris i must admit this is also one of the best,

i am trying to show this date as well ,but i am getting error since this already CASTed.

...

Hello Chris,

We are reached almost near to our result,

But i can see two issues which is occurring when shift schedule changing time,

my query example for one person_num 20345,

action_idCreation_Date ...