<div>
<div class="content wysiwyg-content">
Hello,<br />
I have a table with events and each event has a date.<br />
I want to select all events that do not collide with periods of another table.<br />
For example:<br />
Events table: &nbsp;EventId int, MyDate date, <br />
Execption table: &nbsp;PeriodId int, StartDate date, EndDate date<br />
<br />
EventTable<br />
EventId=1, MyDate='2015-01-03'<br />
EventId=2, MyDate='2015-01-25'<br />
<br />
ExceptionTable<br />
PeriodId=1, StartDate='2015-01-02', EndDate='2015-01-08'<br />
<br />
The result would be EventId=2, MyDate='2015-01-25'<br />
The reason why eventId=1 is not selected is because it is between startdate and enddate of the exception table.<br />
<br />
What is the most efficent way to write a query for this?
</div>
</div>


Hello,
I have a table with events and each event has a date.
I want to select all events that do not collide with periods of another table.
For example:
Events table:  EventId int, MyDate date, 
Execption table:  PeriodId int, StartDate date, EndDate date

EventTable
EventId=1, MyDate='2015-01-03'
EventId=2, MyDate='2015-01-25'

ExceptionTable
PeriodId=1, StartDate='2015-01-02', EndDate='2015-01-08'

The result would be EventId=2, MyDate='2015-01-25'
The reason why eventId=1 is not selected is because it is between startdate and enddate of the exception table.

What is the most efficent way to write a query for this?

Events that are not between dates

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.