I have a table with the following schema:
One record in this table contatis the following data:
ID StartDate EndDate
1 2010-11-30 2011-05-16
I need to know if the Strat/End Date record is between a range, for example '2011-04-16' and '2011-05-15'.
How can I achieve this with SQL Server ?