Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maamer
Starting Member
2 Posts |
 Posted - 2007-11-17 : 17:37:13
|
Carer and patients.Carer should at work with patienteach carer gives his shedule day by day exple:carer1mondayfrom 02/01/2000 15:30 to 03/01/2000 15:30tuesdayfrom 03/01/2000 15:30 à 04/01/2000 15:30wednesdayoffthursdayfrom 05/01/2000 10:00 to 05/01/2000 12:00thursday again 05/01/2000 14:00 to 05/01/2000 16:00and so on...for staff2 and staff3...Question : witch staff is available for patient x a who need a carer from 02/01/2000 15:30 to 04/01/2000 15:30Note : carer mast be available all long of the duration of helpThanksstructure table(id,start,finish,idstaff) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 21:23:27
|
| Some question again?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=92869 |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-17 : 21:41:33
|
You would be more likely to get an answer if you followed the advice here:http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxWhat you have essentially done is ask (twice) for the volunteers here to do the work for you instead of help you understand how to do it yourself.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
carer availability