J
Jeff C
I routinely run a left sided update query on a dataset imported from an ASCII
file. This appends new employees to a Master Employee Table and updates any
changes in base rate pay based on their hours worked and gross wage. The
Overtime Rate, which can change every pay period based on shifts and
differentials etc., is also calculated based on Hours Worked and Gross
Overtime Wage.
I would like to preserve each pay period's wage rates.
Can anyone suggest code that will add a new column each time I run the
query, one for NewBaseRate and one for NewOvertimeRate? If there is a
suggestion for a different method of accomplishing the same thing,
please....offer, I am just trying to get the job done. Thank you in advance.
file. This appends new employees to a Master Employee Table and updates any
changes in base rate pay based on their hours worked and gross wage. The
Overtime Rate, which can change every pay period based on shifts and
differentials etc., is also calculated based on Hours Worked and Gross
Overtime Wage.
I would like to preserve each pay period's wage rates.
Can anyone suggest code that will add a new column each time I run the
query, one for NewBaseRate and one for NewOvertimeRate? If there is a
suggestion for a different method of accomplishing the same thing,
please....offer, I am just trying to get the job done. Thank you in advance.