So, say I have a record where StartTime is '2013-06-07 13:00:00.000' and EndTime is '2013-06-07 13:02:00.000'
Is there a way to have T-SQL select this record if I'm querying for time between StartTime and EndTime that is '2013-06-07 13:01:00.000'? Essentially I'm looking for all records where StartTime and EndTime overlap with the time I'm querying for.
I can't figure out the syntax for it, and I'm not having any luck searching for it.
Thanks for any help you can provide!