I need a stored procedure that will read in columns EmpID,RecType,LoginDateTime. RecType of 1 is for login 2, for logout. For a given period needs to pair the punches (two pairs per day usually, but can more more or less).
the difference of the paired punches are summed as a Double.
I currently have this sp but it takes around 30 secs to run. The last version took around 5 secs.
7 freelancers are bidding on average $125 for this job
I have more than 5 years of professional and practical experience in SQL and database development. I have more than 1800 answers in Stackoverflow(Q&A Site) [url removed, login to view]
Hi. Thanks for your posting. I am familiar with stored procedure. I have created many of mysql stored procedure. I can certainly help you in this project. I hope work with you soon. Thanks.