Microsoft SQL Server

  • 23 min to read

Use the following SQL script to generate data tables with sample data for the Gantt's objects (tasks, dependencies, resources).


CREATE TABLE [dbo].[TaskDependecies](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [ParentID] [int] NULL,
    [DependentID] [int] NULL,
    [Type] [int] NULL,
 CONSTRAINT [PK_TaskDependecies] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[Tasks](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [ParentID] [int] NULL,
    [Subject] [nvarchar](max) NULL,
    [Description] [nvarchar](max) NULL,
    [StartDate] [datetime] NOT NULL,
    [EndDate] [datetime] NOT NULL,
    [PercentComplete] [int] NULL,
    [Type] [int] NULL,
    [Status] [int] NULL,
    [Teams] [nvarchar](max) NULL,
 CONSTRAINT [PK_Tasks] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo].[TaskTeamRelations](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [TaskID] [int] NULL,
    [TeamID] [int] NULL,
 CONSTRAINT [PK_TaskTeamRelations] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[Teams](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [Name] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

The following script fills the data source with sample data:

SET IDENTITY_INSERT [dbo].[TaskDependecies] ON 

INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (0, 0, 1, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (1, 1, 2, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (2, 2, 3, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (3, 3, 4, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (4, 4, 5, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (5, 5, 6, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (6, 6, 7, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (7, 7, 8, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (8, 8, 9, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (9, 9, 10, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (10, 10, 11, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (11, 11, 12, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (12, 12, 13, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (13, 13, 14, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (14, 14, 15, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (15, 15, 16, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (16, 16, 17, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (17, 17, 18, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (18, 18, 19, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (19, 19, 20, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (20, 20, 21, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (21, 21, 22, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (22, 22, 23, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (23, 23, 24, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (24, 24, 25, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (25, 25, 26, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (26, 26, 27, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (27, 27, 28, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (28, 28, 29, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (29, 29, 30, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (30, 30, 31, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (31, 31, 32, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (32, 32, 33, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (33, 33, 34, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (34, 34, 35, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (35, 35, 36, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (36, 36, 37, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (37, 37, 38, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (38, 38, 39, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (39, 39, 40, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (40, 40, 41, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (41, 41, 42, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (42, 42, 43, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (43, 43, 44, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (44, 44, 45, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (45, 45, 46, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (46, 46, 47, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (47, 47, 48, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (48, 48, 49, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (49, 49, 50, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (50, 50, 51, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (51, 51, 52, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (52, 52, 53, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (53, 53, 54, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (54, 54, 55, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (55, 55, 56, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (56, 56, 57, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (57, 57, 58, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (58, 58, 59, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (59, 59, 60, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (60, 60, 61, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (61, 61, 62, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (62, 62, 63, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (63, 63, 64, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (64, 64, 65, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (65, 65, 66, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (66, 66, 67, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (67, 67, 68, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (68, 68, 69, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (69, 69, 70, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (70, 70, 71, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (71, 71, 72, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (72, 72, 73, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (73, 73, 74, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (74, 74, 75, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (75, 75, 76, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (76, 76, 77, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (77, 77, 78, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (78, 78, 79, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (79, 79, 80, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (80, 80, 81, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (81, 81, 82, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (82, 82, 83, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (83, 83, 84, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (84, 84, 85, 0)
INSERT [dbo].[TaskDependecies] ([ID], [ParentID], [DependentID], [Type]) VALUES (85, 85, 86, 0)
SET IDENTITY_INSERT [dbo].[TaskDependecies] OFF
SET IDENTITY_INSERT [dbo].[Tasks] ON 

INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (0, NULL, N'Software Development', NULL, CAST(N'2019-02-21 08:00:00.000' AS DateTime), CAST(N'2019-07-04 15:00:00.000' AS DateTime), 31, 1, 0, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (1, 0, N'Scope', NULL, CAST(N'2019-02-21 08:00:00.000' AS DateTime), CAST(N'2019-02-26 12:00:00.000' AS DateTime), 60, 1, 1, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (2, 1, N'Determine project scope', NULL, CAST(N'2019-02-21 08:00:00.000' AS DateTime), CAST(N'2019-02-21 12:00:00.000' AS DateTime), 100, 1, 2, N'1')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (3, 1, N'Secure project sponsorship', NULL, CAST(N'2019-02-21 13:00:00.000' AS DateTime), CAST(N'2019-02-22 12:00:00.000' AS DateTime), 100, 1, 2, N'1')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (4, 1, N'Define preliminary resources', NULL, CAST(N'2019-02-22 13:00:00.000' AS DateTime), CAST(N'2019-02-25 12:00:00.000' AS DateTime), 60, 1, 2, N'2')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (5, 1, N'Secure core resources', NULL, CAST(N'2019-02-25 13:00:00.000' AS DateTime), CAST(N'2019-02-26 12:00:00.000' AS DateTime), 0, 1, 2, N'2')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (6, 1, N'Scope complete', NULL, CAST(N'2019-02-26 12:00:00.000' AS DateTime), CAST(N'2019-02-26 12:00:00.000' AS DateTime), 0, 0, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (7, 0, N'Analysis/Software Requirements', NULL, CAST(N'2019-02-26 13:00:00.000' AS DateTime), CAST(N'2019-03-18 12:00:00.000' AS DateTime), 80, 1, 1, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (8, 7, N'Conduct needs analysis', NULL, CAST(N'2019-02-26 13:00:00.000' AS DateTime), CAST(N'2019-03-05 12:00:00.000' AS DateTime), 100, 1, 2, N'3')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (9, 7, N'Draft preliminary software specifications', NULL, CAST(N'2019-03-05 13:00:00.000' AS DateTime), CAST(N'2019-03-08 12:00:00.000' AS DateTime), 100, 1, 2, N'3')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (10, 7, N'Develop preliminary budget', NULL, CAST(N'2019-03-08 13:00:00.000' AS DateTime), CAST(N'2019-03-12 12:00:00.000' AS DateTime), 100, 1, 2, N'2')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (11, 7, N'Review software specifications/budget with team', NULL, CAST(N'2019-03-12 13:00:00.000' AS DateTime), CAST(N'2019-03-12 17:00:00.000' AS DateTime), 100, 1, 2, N'2,3')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (12, 7, N'Incorporate feedback on software specifications', NULL, CAST(N'2019-03-13 08:00:00.000' AS DateTime), CAST(N'2019-03-13 17:00:00.000' AS DateTime), 70, 1, 2, N'3')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (13, 7, N'Develop delivery timeline', NULL, CAST(N'2019-03-14 08:00:00.000' AS DateTime), CAST(N'2019-03-14 17:00:00.000' AS DateTime), 0, 1, 2, N'2')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (14, 7, N'Obtain approvals to proceed (concept, timeline, budget)', NULL, CAST(N'2019-03-15 08:00:00.000' AS DateTime), CAST(N'2019-03-15 12:00:00.000' AS DateTime), 0, 1, 2, N'1,2')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (15, 7, N'Secure required resources', NULL, CAST(N'2019-03-15 13:00:00.000' AS DateTime), CAST(N'2019-03-18 12:00:00.000' AS DateTime), 0, 1, 2, N'2')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (16, 7, N'Analysis complete', NULL, CAST(N'2019-03-18 12:00:00.000' AS DateTime), CAST(N'2019-03-18 12:00:00.000' AS DateTime), 0, 0, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (17, 0, N'Design', NULL, CAST(N'2019-03-18 13:00:00.000' AS DateTime), CAST(N'2019-04-05 17:00:00.000' AS DateTime), 80, 1, 1, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (18, 17, N'Review preliminary software specifications', NULL, CAST(N'2019-03-18 13:00:00.000' AS DateTime), CAST(N'2019-03-20 12:00:00.000' AS DateTime), 100, 1, 2, N'3')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (19, 17, N'Develop functional specifications', NULL, CAST(N'2019-03-20 13:00:00.000' AS DateTime), CAST(N'2019-03-27 12:00:00.000' AS DateTime), 100, 1, 2, N'3')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (20, 17, N'Develop prototype based on functional specifications', NULL, CAST(N'2019-03-27 13:00:00.000' AS DateTime), CAST(N'2019-04-02 12:00:00.000' AS DateTime), 100, 1, 2, N'3')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (21, 17, N'Review functional specifications', NULL, CAST(N'2019-04-02 13:00:00.000' AS DateTime), CAST(N'2019-04-04 12:00:00.000' AS DateTime), 30, 1, 2, N'1')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (22, 17, N'Incorporate feedback into functional specifications', NULL, CAST(N'2019-04-04 13:00:00.000' AS DateTime), CAST(N'2019-04-05 12:00:00.000' AS DateTime), 0, 1, 2, N'1')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (23, 17, N'Obtain approval to proceed', NULL, CAST(N'2019-04-05 13:00:00.000' AS DateTime), CAST(N'2019-04-05 17:00:00.000' AS DateTime), 0, 1, 2, N'1,2')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (24, 17, N'Design complete', NULL, CAST(N'2019-04-05 17:00:00.000' AS DateTime), CAST(N'2019-04-05 17:00:00.000' AS DateTime), 0, 0, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (25, 0, N'Development', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-05-07 15:00:00.000' AS DateTime), 42, 1, 1, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (26, 25, N'Review functional specifications', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-04-08 17:00:00.000' AS DateTime), 100, 1, 2, N'4')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (27, 25, N'Identify modular/tiered design parameters', NULL, CAST(N'2019-04-09 08:00:00.000' AS DateTime), CAST(N'2019-04-09 17:00:00.000' AS DateTime), 100, 1, 2, N'4')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (28, 25, N'Assign development staff', NULL, CAST(N'2019-04-10 08:00:00.000' AS DateTime), CAST(N'2019-04-10 17:00:00.000' AS DateTime), 100, 1, 2, N'4')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (29, 25, N'Develop code', NULL, CAST(N'2019-04-11 08:00:00.000' AS DateTime), CAST(N'2019-05-01 17:00:00.000' AS DateTime), 49, 1, 2, N'4')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (30, 25, N'Developer testing (primary debugging)', NULL, CAST(N'2019-04-16 15:00:00.000' AS DateTime), CAST(N'2019-05-07 15:00:00.000' AS DateTime), 24, 1, 2, N'4')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (31, 25, N'Development complete', NULL, CAST(N'2019-05-07 15:00:00.000' AS DateTime), CAST(N'2019-05-07 15:00:00.000' AS DateTime), 0, 0, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (32, 0, N'Testing', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-06-13 15:00:00.000' AS DateTime), 23, 1, 1, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (33, 32, N'Develop unit test plans using product specifications', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-04-11 17:00:00.000' AS DateTime), 100, 1, 2, N'5')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (34, 32, N'Develop integration test plans using product specifications', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-04-11 17:00:00.000' AS DateTime), 100, 1, 2, N'5')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (35, 32, N'Unit Testing', NULL, CAST(N'2019-05-07 15:00:00.000' AS DateTime), CAST(N'2019-05-28 15:00:00.000' AS DateTime), 0, 1, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (36, 35, N'Review modular code', NULL, CAST(N'2019-05-07 15:00:00.000' AS DateTime), CAST(N'2019-05-14 15:00:00.000' AS DateTime), 0, 1, 3, N'5')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (37, 35, N'Test component modules to product specifications', NULL, CAST(N'2019-05-14 15:00:00.000' AS DateTime), CAST(N'2019-05-16 15:00:00.000' AS DateTime), 0, 1, 3, N'5')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (38, 35, N'Identify anomalies to product specifications', NULL, CAST(N'2019-05-16 15:00:00.000' AS DateTime), CAST(N'2019-05-21 15:00:00.000' AS DateTime), 0, 1, 3, N'5')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (39, 35, N'Modify code', NULL, CAST(N'2019-05-21 15:00:00.000' AS DateTime), CAST(N'2019-05-24 15:00:00.000' AS DateTime), 0, 1, 3, N'5')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (40, 35, N'Re-test modified code', NULL, CAST(N'2019-05-24 15:00:00.000' AS DateTime), CAST(N'2019-05-28 15:00:00.000' AS DateTime), 0, 1, 3, N'5')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (41, 35, N'Unit testing complete', NULL, CAST(N'2019-05-28 15:00:00.000' AS DateTime), CAST(N'2019-05-28 15:00:00.000' AS DateTime), 0, 0, 3, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (42, 32, N'Integration Testing', NULL, CAST(N'2019-05-28 15:00:00.000' AS DateTime), CAST(N'2019-06-13 15:00:00.000' AS DateTime), 0, 1, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (43, 42, N'Test module integration', NULL, CAST(N'2019-05-28 15:00:00.000' AS DateTime), CAST(N'2019-06-04 15:00:00.000' AS DateTime), 0, 1, 3, N'5')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (44, 42, N'Identify anomalies to specifications', NULL, CAST(N'2019-06-04 15:00:00.000' AS DateTime), CAST(N'2019-06-06 15:00:00.000' AS DateTime), 0, 1, 3, N'5')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (45, 42, N'Modify code', NULL, CAST(N'2019-06-06 15:00:00.000' AS DateTime), CAST(N'2019-06-11 15:00:00.000' AS DateTime), 0, 1, 3, N'5')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (46, 42, N'Re-test modified code', NULL, CAST(N'2019-06-11 15:00:00.000' AS DateTime), CAST(N'2019-06-13 15:00:00.000' AS DateTime), 0, 1, 3, N'5')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (47, 42, N'Integration testing complete', NULL, CAST(N'2019-06-13 15:00:00.000' AS DateTime), CAST(N'2019-06-13 15:00:00.000' AS DateTime), 0, 0, 3, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (48, 0, N'Training', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-06-10 15:00:00.000' AS DateTime), 25, 1, 1, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (49, 48, N'Develop training specifications for end users', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-04-10 17:00:00.000' AS DateTime), 100, 1, 2, N'6')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (50, 48, N'Develop training specifications for helpdesk support staff', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-04-10 17:00:00.000' AS DateTime), 100, 1, 2, N'6')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (51, 48, N'Identify training delivery methodology (computer based training, classroom, etc.)', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-04-09 17:00:00.000' AS DateTime), 100, 1, 2, N'6')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (52, 48, N'Develop training materials', NULL, CAST(N'2019-05-07 15:00:00.000' AS DateTime), CAST(N'2019-05-28 15:00:00.000' AS DateTime), 0, 1, 2, N'6')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (53, 48, N'Conduct training usability study', NULL, CAST(N'2019-05-28 15:00:00.000' AS DateTime), CAST(N'2019-06-03 15:00:00.000' AS DateTime), 0, 1, 2, N'6')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (54, 48, N'Finalize training materials', NULL, CAST(N'2019-06-03 15:00:00.000' AS DateTime), CAST(N'2019-06-06 15:00:00.000' AS DateTime), 0, 1, 2, N'6')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (55, 48, N'Develop training delivery mechanism', NULL, CAST(N'2019-06-06 15:00:00.000' AS DateTime), CAST(N'2019-06-10 15:00:00.000' AS DateTime), 0, 1, 2, N'6')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (56, 48, N'Training materials complete', NULL, CAST(N'2019-06-10 15:00:00.000' AS DateTime), CAST(N'2019-06-10 15:00:00.000' AS DateTime), 0, 0, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (57, 0, N'Documentation', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-05-20 12:00:00.000' AS DateTime), 0, 1, 1, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (58, 57, N'Develop Help specification', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-04-08 17:00:00.000' AS DateTime), 80, 1, 2, N'7')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (59, 57, N'Develop Help system', NULL, CAST(N'2019-04-22 13:00:00.000' AS DateTime), CAST(N'2019-05-13 12:00:00.000' AS DateTime), 0, 1, 2, N'7')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (60, 57, N'Review Help documentation', NULL, CAST(N'2019-05-13 13:00:00.000' AS DateTime), CAST(N'2019-05-16 12:00:00.000' AS DateTime), 0, 1, 2, N'7')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (61, 57, N'Incorporate Help documentation feedback', NULL, CAST(N'2019-05-16 13:00:00.000' AS DateTime), CAST(N'2019-05-20 12:00:00.000' AS DateTime), 0, 1, 2, N'7')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (62, 57, N'Develop user manuals specifications', NULL, CAST(N'2019-04-08 08:00:00.000' AS DateTime), CAST(N'2019-04-09 17:00:00.000' AS DateTime), 65, 1, 2, N'7')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (63, 57, N'Develop user manuals', NULL, CAST(N'2019-04-22 13:00:00.000' AS DateTime), CAST(N'2019-05-13 12:00:00.000' AS DateTime), 0, 1, 2, N'7')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (64, 57, N'Review all user documentation', NULL, CAST(N'2019-05-13 13:00:00.000' AS DateTime), CAST(N'2019-05-15 12:00:00.000' AS DateTime), 0, 1, 2, N'7')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (65, 57, N'Incorporate user documentation feedback', NULL, CAST(N'2019-05-15 13:00:00.000' AS DateTime), CAST(N'2019-05-17 12:00:00.000' AS DateTime), 0, 1, 2, N'7')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (66, 57, N'Documentation complete', NULL, CAST(N'2019-05-20 12:00:00.000' AS DateTime), CAST(N'2019-05-20 12:00:00.000' AS DateTime), 0, 0, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (67, 0, N'Pilot', NULL, CAST(N'2019-03-18 13:00:00.000' AS DateTime), CAST(N'2019-06-24 15:00:00.000' AS DateTime), 22, 1, 1, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (68, 67, N'Identify test group', NULL, CAST(N'2019-03-18 13:00:00.000' AS DateTime), CAST(N'2019-03-19 12:00:00.000' AS DateTime), 100, 1, 2, N'2')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (69, 67, N'Develop software delivery mechanism', NULL, CAST(N'2019-03-19 13:00:00.000' AS DateTime), CAST(N'2019-03-20 12:00:00.000' AS DateTime), 100, 1, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (70, 67, N'Install/deploy software', NULL, CAST(N'2019-06-13 15:00:00.000' AS DateTime), CAST(N'2019-06-14 15:00:00.000' AS DateTime), 0, 1, 2, N'8')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (71, 67, N'Obtain user feedback', NULL, CAST(N'2019-06-14 15:00:00.000' AS DateTime), CAST(N'2019-06-21 15:00:00.000' AS DateTime), 0, 1, 2, N'8')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (72, 67, N'Evaluate testing information', NULL, CAST(N'2019-06-21 15:00:00.000' AS DateTime), CAST(N'2019-06-24 15:00:00.000' AS DateTime), 0, 1, 2, N'8')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (73, 67, N'Pilot complete', NULL, CAST(N'2019-06-24 15:00:00.000' AS DateTime), CAST(N'2019-06-24 15:00:00.000' AS DateTime), 0, 0, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (74, 0, N'Deployment', NULL, CAST(N'2019-06-24 15:00:00.000' AS DateTime), CAST(N'2019-07-01 15:00:00.000' AS DateTime), 0, 1, 1, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (75, 74, N'Determine final deployment strategy', NULL, CAST(N'2019-06-24 15:00:00.000' AS DateTime), CAST(N'2019-06-25 15:00:00.000' AS DateTime), 0, 1, 2, N'8')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (76, 74, N'Develop deployment methodology', NULL, CAST(N'2019-06-25 15:00:00.000' AS DateTime), CAST(N'2019-06-26 15:00:00.000' AS DateTime), 0, 1, 2, N'8')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (77, 74, N'Secure deployment resources', NULL, CAST(N'2019-06-26 15:00:00.000' AS DateTime), CAST(N'2019-06-27 15:00:00.000' AS DateTime), 0, 1, 2, N'8')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (78, 74, N'Train support staff', NULL, CAST(N'2019-06-27 15:00:00.000' AS DateTime), CAST(N'2019-06-28 15:00:00.000' AS DateTime), 0, 1, 2, N'8')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (79, 74, N'Deploy software', NULL, CAST(N'2019-06-28 15:00:00.000' AS DateTime), CAST(N'2019-07-01 15:00:00.000' AS DateTime), 0, 1, 2, N'8')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (80, 74, N'Deployment complete', NULL, CAST(N'2019-07-01 15:00:00.000' AS DateTime), CAST(N'2019-07-01 15:00:00.000' AS DateTime), 0, 0, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (81, 0, N'Post Implementation Review', NULL, CAST(N'2019-07-01 15:00:00.000' AS DateTime), CAST(N'2019-07-04 15:00:00.000' AS DateTime), 0, 1, 1, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (82, 81, N'Document lessons learned', NULL, CAST(N'2019-07-01 15:00:00.000' AS DateTime), CAST(N'2019-07-02 15:00:00.000' AS DateTime), 0, 1, 2, N'2')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (83, 81, N'Distribute to team members', NULL, CAST(N'2019-07-02 15:00:00.000' AS DateTime), CAST(N'2019-07-03 15:00:00.000' AS DateTime), 0, 1, 2, N'2')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (84, 81, N'Create software maintenance team', NULL, CAST(N'2019-07-03 15:00:00.000' AS DateTime), CAST(N'2019-07-04 15:00:00.000' AS DateTime), 0, 1, 2, N'2')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (85, 81, N'Post implementation review complete', NULL, CAST(N'2019-07-04 15:00:00.000' AS DateTime), CAST(N'2019-07-04 15:00:00.000' AS DateTime), 0, 0, 2, N'')
INSERT [dbo].[Tasks] ([ID], [ParentID], [Subject], [Description], [StartDate], [EndDate], [PercentComplete], [Type], [Status], [Teams]) VALUES (86, 0, N'Software development template complete', NULL, CAST(N'2019-07-04 15:00:00.000' AS DateTime), CAST(N'2019-07-04 15:00:00.000' AS DateTime), 0, 0, 1, N'')
SET IDENTITY_INSERT [dbo].[Tasks] OFF
SET IDENTITY_INSERT [dbo].[TaskTeamRelations] ON 

INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (0, 2, 1)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (1, 3, 1)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (2, 4, 2)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (3, 5, 2)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (4, 8, 3)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (5, 9, 3)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (6, 10, 2)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (7, 11, 2)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (8, 11, 3)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (9, 12, 3)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (10, 13, 2)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (11, 14, 1)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (12, 14, 2)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (13, 15, 2)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (14, 18, 3)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (15, 19, 3)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (16, 20, 3)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (17, 21, 1)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (18, 22, 1)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (19, 23, 1)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (20, 23, 2)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (21, 26, 4)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (22, 27, 4)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (23, 28, 4)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (24, 29, 4)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (25, 30, 4)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (26, 33, 5)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (27, 34, 5)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (28, 36, 5)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (29, 37, 5)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (30, 38, 5)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (31, 39, 5)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (32, 40, 5)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (33, 43, 5)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (34, 44, 5)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (35, 45, 5)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (36, 46, 5)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (37, 49, 6)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (38, 50, 6)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (39, 51, 6)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (40, 52, 6)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (41, 53, 6)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (42, 54, 6)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (43, 55, 6)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (44, 58, 7)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (45, 59, 7)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (46, 60, 7)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (47, 61, 7)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (48, 62, 7)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (49, 63, 7)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (50, 64, 7)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (51, 65, 7)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (52, 68, 2)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (53, 70, 8)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (54, 71, 8)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (55, 72, 8)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (56, 75, 8)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (57, 76, 8)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (58, 77, 8)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (59, 78, 8)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (60, 79, 8)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (61, 82, 2)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (62, 83, 2)
INSERT [dbo].[TaskTeamRelations] ([ID], [TaskID], [TeamID]) VALUES (63, 84, 2)
SET IDENTITY_INSERT [dbo].[TaskTeamRelations] OFF
SET IDENTITY_INSERT [dbo].[Teams] ON 

INSERT [dbo].[Teams] ([ID], [Name]) VALUES (1, N'Management')
INSERT [dbo].[Teams] ([ID], [Name]) VALUES (2, N'Project Manager')
INSERT [dbo].[Teams] ([ID], [Name]) VALUES (3, N'Analyst')
INSERT [dbo].[Teams] ([ID], [Name]) VALUES (4, N'Developer')
INSERT [dbo].[Teams] ([ID], [Name]) VALUES (5, N'Testers')
INSERT [dbo].[Teams] ([ID], [Name]) VALUES (6, N'Trainers')
INSERT [dbo].[Teams] ([ID], [Name]) VALUES (7, N'Technical Communicators')
INSERT [dbo].[Teams] ([ID], [Name]) VALUES (8, N'Deployment Team')
SET IDENTITY_INSERT [dbo].[Teams] OFF
USE [master]
GO
ALTER DATABASE [DevelopmentGantt] SET  READ_WRITE 
GO