schedule ideas

[Ecreations]

Hey Guys,
starting a new project here and would appreciate any input or hints on this issue.
Need to schedule employees based on the availablity to perform tasks at clients locations
example
Client calls to book an appointment, dispacher would search based on the time and date client provides and book the call with the first available employee.
my problem with this system is the fact that all Skus "Tasks employees are dispached to perform" are based on 1 hour increment and have never done any checking for time overlapping. I need to make sure We dont book someone who is already booked or is not working that day at all.

Any ideas or input will be appreciated

Thanks

http://ecreationscanada.com

What would you attempt to accomplish if you knew you would not fail?

 

[jbenson001]

What would be the critera for "First available employee"?
Since I don't know the tables structure, maybe:

Select TOP 1 <cols> from <sometable>
Where date is <> <datetime passed in>
order by???

To not schedule someone who is not working, you would need some sort of status column to signify if they are available or not:

Select TOP 1 <cols> from <sometable>
Where date is <> <datetime passed in>
and status = "Available:"order by???

Just some of my thoughts...
Jim