query for between dates

[icanmakeiteasy]

hi, i have a proble please help me i hav a table which consists of userid and date

table1
userid startdate enddate
100 04/2/2009 04/30/2009

user 100 is under work from 2nd april to 30th april if i try to give work from 04/10/2009 to 04/20/2009 to the user 100 now i should show that the user is already in work for given dates how can I?? thanks in advance...

icanmakeiteasy

[Wendelius]

You can test the row and if the query returns a result they dates overlap. For example

select ...
from table1
where (startdate between convert(datetime, '04/10/2009', 101) and convert('04/20/2009', 101)
or enddate between convert(datetime, '04/10/2009', 101) and convert('04/20/2009', 101))
and userid = 100

However, use parameters instead of literals to define the start and end dates.

The need to optimize rises from a bad design.My articles[^]

[icanmakeiteasy]

thx man thank you very much

icanmakeiteasy

[Wendelius]

You're welcome.

The need to optimize rises from a bad design.My articles[^]