MSSQL 2000 Stored Procedure to Split Shift Times
- by JClaspill
I am being asked to alter a system to include the ability to have pay differentials based on hours worked. The old method included a stored procedure (MSSQL2000 db) that did the basics, but simply knows the start and end of every shift.
So, this is the information I start with:
EMPLOYEE | TYPE | HOURS | INSTAMP | OUTSTAMP…