I'm running SQL Server 2005 and Visual Studio 2005 but the server where this all will happen is running SQL Server 2008.
At the company where I work hourly employee time is tracked using several methods, sometimes more than one method per employee per day.
A job runs daily which calls several stored procedures and collects all the time data from the various sources and creates a time card. Employees then have the option to dispute, or not, the time recorded on their card the next day. They can
dispute, concur or take no action which results in a default approval. Employees are then paid off the hours credited to them on their time cards.
Problem: Business rules for one particular business unit were improperly applied, resulting in employees missing a few minutes here and there on their time cards. All employees except one disputed the time, had their cards corrected and the business
rules have since been corrected. The employee who failed to dispute has a period of about 4 months where he is, probably, owed a few hours back pay.
To resolve this issue I have to query to see what hours the employee WAS credited for, then clear out the time cards and re-run the time card creation for the four month period (this time with rules applied properly), query THAT result to see what hours
the employee SHOULD have been credit
View Complete Post