Hi,
I've checked the MS Knowledgebase for a bug, but cannot seem to find the problem...Below is a query that succeeds with certain ID's and fails (error 1203) with others. Note that it succeeds if I remove 'Top 1' from the select statement. Any idea what the problem might be? We're running Sql2000 w/most current service packs/hotfixes.
SELECT TOP 1 rwo.ID AS rotwkoffID FROM (rotWeekOffered rwo join rotSemesterOffered rso on rwo.rotSemID=rso.ID) join rotation on rotation.ID=rso.rotID,rotWeek WHERE rwo.rotWeekID=rotWeek.ID AND rotWeek.isSched=1 AND rotation.rottype='e' AND rotation.abbreviation='IS' AND rso.semester='2' AND rso.yr='2004' AND rso.ID NOT IN(SELECT rwo2.rotSemID FROM rotSched join rotWeekOffered rwo2 on rotSched.rotwkoffid=rwo2.ID WHERE int_ref_id='11111') AND rotWeek.ID not in (select rw.ID from (rotWeek rw join rotweekoffered rwo on rw.ID=rwo.rotweekID) left join rotsched on rotSched.rotwkoffID=rwo.ID WHERE rotSched.int_ref_id='11111')
Thanks!
I've checked the MS Knowledgebase for a bug, but cannot seem to find the problem...Below is a query that succeeds with certain ID's and fails (error 1203) with others. Note that it succeeds if I remove 'Top 1' from the select statement. Any idea what the problem might be? We're running Sql2000 w/most current service packs/hotfixes.
SELECT TOP 1 rwo.ID AS rotwkoffID FROM (rotWeekOffered rwo join rotSemesterOffered rso on rwo.rotSemID=rso.ID) join rotation on rotation.ID=rso.rotID,rotWeek WHERE rwo.rotWeekID=rotWeek.ID AND rotWeek.isSched=1 AND rotation.rottype='e' AND rotation.abbreviation='IS' AND rso.semester='2' AND rso.yr='2004' AND rso.ID NOT IN(SELECT rwo2.rotSemID FROM rotSched join rotWeekOffered rwo2 on rotSched.rotwkoffid=rwo2.ID WHERE int_ref_id='11111') AND rotWeek.ID not in (select rw.ID from (rotWeek rw join rotweekoffered rwo on rw.ID=rwo.rotweekID) left join rotsched on rotSched.rotwkoffID=rwo.ID WHERE rotSched.int_ref_id='11111')
Thanks!
