Check Date range in between date range query

• rahulpatel112

  SSC-Addicted

  Points: 419

  More actions

  May 3, 2012 at 12:53 am

  #257329

  Hello friends,

  I need query which will check user supplied date range is in between the existing table startdate and enddate.

  if any of the date of user supplied date range is in between the tables start date and end date,it should retrun that record from table.

  for example user supply date range is from 1 may 2012 to 5 may 2012.

  then query must check that

  1 may 2005

  2 may 2005

  3 may 2005

  4 may 2005

  5 may 2005

  (all dates) is in between startdate and enddate of existing table.

  please reply...

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  May 3, 2012 at 1:05 am

  #1482825

  two user parameteres in @StartDate and @EndDate

  two parameters to store min and max date in the table @MinDate and @MaxDate

  select the min and max date from the table

  SELECT @MinDate = MIN(DATE), @MaxDate = MAX(DATE) FROM table

  IF @StartDate >= @MinDate AND @EndDate <= @MaxDate

  BEGIN

  SELECT

  .....

  FROM

  .....

  JOIN

  ....

  WHERE

  Date >= @StartDate AND Date <=@EndDate

  END