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 |
|
wormz666
Posting Yak Master
110 Posts |
 Posted - 2010-03-04 : 14:37:25
|
| hello everyone i have a table schedule and s_taken and subject and sec_subjectmy primary concerncan i query??? in my table schedulei have s_day where rule is Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Monday And Wednesday,Tuesday And Thursday, Monday To Friday and a field time_start and time_end, subjcodein my table s_taken is where the subject i use to not to filterand in table subject subjcode and requirequi field function is to verify my subject if i am qualified to take it.........sec_subjfield s_sched, this is where i get my regular subjecti want a query that will suggest me the schedule that will not be conflict with my regular schedule, if i will add some subject.... finding the truthmaking a maze on my mind.... |
|
|
wormz666
Posting Yak Master
110 Posts |
Posted - 2010-03-04 : 14:56:03
|
you might be confuse let say assume this is the tablescheduleschedid day timein timeend subjcode-----------------------------------------------1 monday 8:00 am 9:00 AM 10:00 AM sts12 monday to friday 8:30 am 9:00 AM 10:00 AM fsf13 monday to friday 8:00 am 9:00 AM 10:00 AM sts24 monday 8:30 am 9:00 AM 10:00 AM fsf2subjectsubjcode requi-----------------------------------sts 1 sts 2 sts1fsf 1fsf 2s_takens_id subjcode-------------------------------------1 sts1sec_subjsec_s_id subjcode room schedid------------------------------1 sts2 2 32 fsf2 2 43 sts1 1 14 fsf1 1 2 assume that there are lots of record....finding the truthmaking a maze on my mind.... |
 |
|
|
|
|
|
confuse of conditioning