How to get data from database for gantt chart.(Need sql query for exist/missing data for whole year)

[sadique]

How to get data from database for gantt chart.(Need sql query for exist/missing data for whole year).

 

Like i go for year 2010 and find startdate as 02-03-2010(mm-dd-yyyy) and enddate 04-04-2010.

 

So for above example how i get remaining data for given year.

 

 

 

Thanks in advance.

Edited March 2, 2010 by Guest