Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Possible better way
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Possible better way
Miscellaneous
Thread ID:
01342342
Message ID:
01342342
Views:
51
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
( 
	(@Start > m.begintime AND @Start < m.endtime)
	OR (@End > m.begintime AND @End < m.endtime)
	OR (m.begintime > @Start AND m.begintime < @End)
	OR (m.endtime > @Start AND m.endtime < @End)
	OR (@Start = m.begintime AND @End = m.endtime)
)
Next
Reply
Map
View

Click here to load this message in the networking platform