PLEASE HELP!!!!
Needing help with developing a stored proc for the following:
Production crews work at the following times:
CREW A = 7:30AM to 3:30PM
CREW B = 3:30PM to 11:30PM
CREW C = 11:30PM to 7:30AM
- There are Record_Begin_Da te and Record_End_Date time/date fields in the database.
- There is logic in place that figures out which shift WAS Working at each time
...