Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I have this data, and would like to sum the time worked. P_TYPE = 1 is for when You sign in, and P_TYPE = 2 is for signing out for breaks or end of day. so my question is hos to do this?
Thanks in advance!
Hi,
It seems ok also when you create a resident table as (PLOCKARE_TID) did you try to drop the earlier table PLOCKARE_TIDSTAMPLINGAR at the end of the load script
Drop Table PLOCKARE_TIDSTAMPLINGAR;
Regards
Anand
Hi,
I have dropped the earlier table now, but still not getting the desired effect.
I have made a minor change in the if statement. but its not calculating the time right?