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.
6 freelance font une offre moyenne de $138 pour ce travail
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]
With my 9+ years of Software Development experience like to work on your project,Please see my reviews to consider me as your development member. ASP.Net, C#, VB.Net, MVC, WPF, Visual Basic, Excel VBA, MS SQL Server Plus
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.