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.