Hello everyone,
I'm looking to accomplish the following; I have two tables one named employee which has two fields employee ID and employee schedule. Then I have another table called schedule with two fields percentage and schedule. I want to randomly update employee schedule with one of the three available schedules, however I want to make sure that only a percentage of the employees are assigned a certain schedule that is why i have a percentage field. i.e schedule1 = 35%, schedule2= 35% and schedule3=30%.
Thank you in advance.
I'm looking to accomplish the following; I have two tables one named employee which has two fields employee ID and employee schedule. Then I have another table called schedule with two fields percentage and schedule. I want to randomly update employee schedule with one of the three available schedules, however I want to make sure that only a percentage of the employees are assigned a certain schedule that is why i have a percentage field. i.e schedule1 = 35%, schedule2= 35% and schedule3=30%.
Thank you in advance.
