>Does anyone know a better way to do this? If I comment out the OR with the Begin and Endtimes, this this is fast. This method is accurate and gets all possibilites, but the duration is 1440 in sql profiler vs 13 without the OR's.
>
>
>
>WHERE m.meetingnumber <> @CaseId
>AND m.patientid = @PatientId
>AND
>(
> ((m.begintime > @Start AND m.begintime < @End)
> OR (m.endtime > @Start AND m.endtime < @End))
>
Would it be quicker this way (removing 3 other conditions for now)?
If it's not broken, fix it until it is.
My Blog