date-range sql statement

[andrewbadera]

Under SQL Serever 2000, I'm trying to pull projects out of the database to display on a 5-day Gantt-style project timeline chart. Therefore, I need all projects that occur on any of the 5 days on the chart (range[dateStart-dateEndProj] contains range[1st day-5th day]). is there a way to pull this data back with a single SQL statement? or would subqueries or a stored proc be more suited for this? right now I'm on a bit of a deadline, and the fastest solution is the best, for hte moment.

tblJob:
intJobID
dateStart
dateEndProj
dateEndAct
hoursAccum
poundsAccum
hoursProj
poundsProj
customerID

 

[vganeshbabu]

use BETWEEN clause in the SQL statement for retrieving records within a date range..

 

[andrewbadera]

I had totally forgotten the BETWEEN, thanks