Wednesday 1 January 2014

Select SQL Between two dates



SELECT * FROM table_name t
 WHERE ((t.start_date <= @StartDate AND t.end_date > @StartDate)
  OR
  (t.start_date < @EndDate AND t.end_date >= @EndDate))