The table we use for our examples is stored in SQL Server 2000. We do
direct SQL reads of data from tblTask (SELECT * FROM tblTask...)
although you could also use stored procedures to retrieve your database info.
| Column Name | Data Type | Length | Allow Nulls |
| ProjectNM | varchar | 25 | 0 |
| TaskID | varchar | 10 | 0 |
| TaskNM | varchar | 50 | 0 |
| PlanStartDT | varchar | 10 | 1 |
| PlanEndDT | varchar | 10 | 1 |
| ActStartDT | varchar | 10 | 1 |
| ActEndDT | varchar | 10 | 1 |
| ForeStartDT | varchar | 10 | 1 |
| ForeEndDT | varchar | 10 | 1 |
| PctCompleteQY | smallint | 2 | 1 |
| HyperlinkURL | varchar | 100 | 1 |
Empty cells are <NULL> values.
| ProjectNM | TaskID | TaskNM | PlanStartDT | PlanEndDT | ActStartDT | ActEndDT | ForeStartDT | ForeEndDT | PctCompleteQY | HyperlinkURL |
| Project A | 1.1 | Define Requirements | 04-07-03 | 04-29-03 | 04-09-03 | 04-25-03 | 04-09-03 | 04-29-03 | 100 | |
| Project A | 1.2 | Solicit bids | 05-01-03 | 06-16-03 | 04-27-03 | 06-20-03 | 04-27-03 | 06-16-03 | 25 | |
| Project A | 1.3 | Award contract | 06-20-03 | 06-20-03 | 06-21-03 | 06-21-03 | ||||
| Project A | 2.1 | Implementation | 06-21-03 | 08-27-03 | 06-22-03 | 09-01-03 | ||||
| Project A | 2.2 | Project complete | 08-28-03 | 08-28-03 | 09-02-03 | 09-02-03 | ||||
| Project B | 1 | Task 1 | 9/1/2002 | 2/28/2003 | 2/10/2003 | 3/18/2003 | 11 | http://www.microsoft.com | ||
| Project B | 2 | Task 2 | 1/10/2003 | 2/28/2003 | 1/25/2003 | 3/10/2003 | 22 | http://www.yahoo.com | ||
| Project B | 3 | Task 3 | 3/1/2003 | 3/30/2003 | 3/5/2003 | 3/31/2003 | 33 | |||
| Project B | 4 | Task 4 | 3/10/2003 | 3/15/2003 | 3/5/2003 | 3/10/2003 | 44 | http://www.msdn.com | ||
| Project B | 5 | Task 5 | 3/15/2003 | 4/22/2003 | 3/25/2003 | 5/15/2003 | 55 | |||
| Project B | 6 | Task 6 | 1/15/2003 | 1/28/2003 | 1/25/2003 | 1/30/2003 | 66 | http://thepcsweb.com | ||
| Project B | 7 | Task 7 | 4/15/2003 | 4/28/2003 | 4/25/2003 | 4/30/2003 | 77 | http://thepcsweb.com/products/webgantt | ||
| Project B | 8 | Task 8 | 5/15/2003 | 5/15/2003 | 5/25/2003 | 5/25/2003 | 88 | |||
| Project C | 1 | Task 1 (completely passed) | 1/23/2003 | 2/20/2003 | 1/23/2003 | 2/20/2003 | ||||
| Project C | 2 | Task 2 (starts before chart) | 2/21/2003 | 4/28/2003 | 2/21/2003 | 4/28/2003 | ||||
| Project C | 3 | Task 3 (within chart) | 5/5/2003 | 7/10/2003 | 5/5/2003 | 7/10/2003 | ||||
| Project C | 4 | Task 4 (ends after chart) | 7/11/2003 | 9/1/2003 | 7/11/2003 | 9/1/2003 | ||||
| Project C | 5 | Task 5 (completely after chart) | 9/10/2003 | 9/15/2003 | 9/10/2003 | 9/15/2003 | ||||
| Project D | 1 | Task 1 | 10.1.2002 | 15.1.2002 | 11.1.2002 | 18.1.2002 | 100 | |||
| Project D | 2 | Task 2 | 17.1.2002 | 22.1.2002 | 19.1.2002 | 28.1.2002 | 100 | |||
| Project D | 3 | Task 3 | 1.2.2002 | 5.2.2002 | 1.2.2002 | 7.2.2002 | 80 | |||
| Project D | 4 | Task 4 | 8.2.2002 | 25.2.2002 | 9.2.2002 | 22.2.2002 | 15 | |||
| Project D | 5 | Task 5 | 2.3.2002 | 22.3.2002 | 3.3.2002 | 25.3.2002 | 0 | |||
| Project D | 6 | Task 6 | 5.3.2002 | 30.3.2002 | 5.3.2002 | 31.3.2002 | 0 | |||
| Project D | 7 | Task 7 | 27.3.2002 | 22.4.2002 | 27.3.2002 | 22.4.2002 | 0 | |||
| Project D | 8 | Task 8 | 5.4.2002 | 30.4.2002 | 5.4.2002 | 10.5.2002 | 0 | |||
| Project E | 1 | Task AAA | 2/15/2003 | 2/22/2003 | 2/16/2003 | 2/26/2003 | ||||
| Project E | 2 | Task BBB | 2/25/2003 | 2/27/2003 | 2/26/2003 | 3/1/2003 | ||||
| Project E | 3 | Task CCC | 3/4/2003 | 4/1/2003 | 3/4/2003 | 3/26/2003 | ||||
| Project E | 4 | Task DDD | 4/2/2003 | 4/25/2003 | 3/26/2003 | 4/25/2003 | ||||
| Project E | 5 | Task EEE | 4/15/2003 | 4/25/2003 | 4/15/2003 | 4/25/2003 | ||||
| Project E | 6 | Task FFF | 5/1/2003 | 5/1/2003 | 5/1/2003 | 5/1/2003 | ||||
| Project F | A | Task Alpha | 1/10/2003 | 4/20/2003 | 1/20/2003 | 4/30/2003 | ||||
| Project F | B | Task Bravo | 3/15/2003 | 6/30/2003 | 3/25/2003 | 7/5/2003 | ||||
| Project F | C | Task Charlie | 5/1/2003 | 10/30/2003 | 5/25/2003 | 11/15/2003 | ||||
| Project F | D | Task Delta | 10/10/2003 | 2/25/2004 | 10/20/2003 | 3/10/2004 | ||||
| Project F | E | Task Echo | 1/15/2004 | 4/22/2004 | 1/25/2004 | 4/15/2004 | ||||
| Project F | F | Task Foxtrot | 4/15/2004 | 8/20/2004 | 4/25/2004 | 9/30/2004 | ||||
| Project F | G | Task Golf | 5/15/2004 | 10/30/2004 | 5/25/2004 | 10/20/2004 |