Microsoft SQL Server

  • 20 minutes 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].[Dependencies](
    [Key] [int] IDENTITY(1,1) NOT NULL,
    [PredecessorKey] [int] NULL,
    [SuccessorKey] [int] NULL,
    [Type] [int] NULL,
 CONSTRAINT [PK_Dependecies] PRIMARY KEY CLUSTERED 
(
    [Key] 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](
    [Key] [int] IDENTITY(1,1) NOT NULL,
    [ParentKey] [int] NULL,
    [Title] [nvarchar](max) NULL,
    [StartDate] [datetime] NOT NULL,
    [EndDate] [datetime] NOT NULL,
    [Progress] [int] NULL,
    [Color] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tasks] PRIMARY KEY CLUSTERED 
(
    [Key] 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].[ResourceAssignments](
    [Key] [int] IDENTITY(1,1) NOT NULL,
    [TaskKey] [int] NULL,
    [ResourceKey] [int] NULL,
 CONSTRAINT [PK_ResourceAssignment] PRIMARY KEY CLUSTERED 
(
    [Key] 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].[Resources](
    [Key] [int] IDENTITY(1,1) NOT NULL,
    [Name] [nvarchar](max) NOT NULL,
    [Color] [varchar](50) NULL,
 CONSTRAINT [PK_Resources] PRIMARY KEY CLUSTERED 
(
    [Key] 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].[Tasks] ON 

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

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

INSERT [dbo].[Resources] ([Key], [Name], [Color]) VALUES (1, N'Management', N' ')
INSERT [dbo].[Resources] ([Key], [Name], [Color]) VALUES (2, N'Project Manager', N' ')
INSERT [dbo].[Resources] ([Key], [Name], [Color]) VALUES (3, N'Analyst', N' ')
INSERT [dbo].[Resources] ([Key], [Name], [Color]) VALUES (4, N'Developer', N' ')
INSERT [dbo].[Resources] ([Key], [Name], [Color]) VALUES (5, N'Testers', N' ')
INSERT [dbo].[Resources] ([Key], [Name], [Color]) VALUES (6, N'Trainers', N' ')
INSERT [dbo].[Resources] ([Key], [Name], [Color]) VALUES (7, N'Technical Communicators', N' ')
INSERT [dbo].[Resources] ([Key], [Name], [Color]) VALUES (8, N'Deployment Team', N' ')
SET IDENTITY_INSERT [dbo].[Resources] OFF
SET IDENTITY_INSERT [dbo].[ResourceAssignments] ON 

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