SET IDENTITY_INSERT dbo.tb_GuysStThomas ON;
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (1,0,N'A',N'Capital Plan',{ts '2007-03-08 12:00:00.000'},{ts '2007-10-19 00:00:00.000'},0.4053452,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (2,0,N'F',N'Strategic Projects',{ts '2006-11-01 12:00:00.000'},{ts '2007-09-14 00:00:00.000'},0.7531173,1,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (3,1,N'F',N'Infrastructure Work Team',{ts '2007-02-01 12:00:00.000'},{ts '2007-09-05 00:00:00.000'},0.772742,1,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (4,2,N'A',N'Guys Tower Façade Feasability',{ts '2007-02-01 12:00:00.000'},{ts '2007-08-01 00:00:00.000'},0.6038781,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (5,2,N'A',N'East Wing Cladding (inc Ward Refurbisments)',{ts '2007-04-21 00:00:00.000'},{ts '2007-09-05 00:00:00.000'},0.9416059,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (6,1,N'F',N'Modernisation Workstream',{ts '2007-01-22 00:00:00.000'},{ts '2007-03-27 12:00:00.000'},0.7276251,1,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (7,2,N'A',N'A&E Reconfiguration',{ts '2007-01-22 00:00:00.000'},{ts '2007-03-27 12:00:00.000'},0.6976744,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (8,2,N'A',N'St. Thomas Main Theatres Study',{ts '2007-01-28 00:00:00.000'},{ts '2007-03-18 12:00:00.000'},0.7575758,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (9,1,N'F',N'Ambulatory Workstream',{ts '2007-03-09 12:00:00.000'},{ts '2007-06-05 12:00:00.000'},0.7318296,1,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (10,2,N'A',N'PET Feasability',{ts '2007-03-09 12:00:00.000'},{ts '2007-06-05 12:00:00.000'},0.7318296,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (11,1,N'F',N'Cancer Workstream',{ts '2006-11-01 12:00:00.000'},{ts '2007-09-14 00:00:00.000'},0.7802728,1,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (12,2,N'A',N'Redevelopment of Guys Site Incorporating Cancer Feasability',{ts '2007-01-11 00:00:00.000'},{ts '2007-08-11 12:00:00.000'},0.7411765,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (13,2,N'A',N'Radiotherapy and Chemotherapy Center',{ts '2006-11-01 12:00:00.000'},{ts '2007-03-30 12:00:00.000'},0.9463087,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (14,2,N'A',N'Decant Facilities',{ts '2007-05-24 12:00:00.000'},{ts '2007-09-14 00:00:00.000'},0.6533333,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (15,0,N'F',N'Capital Projects',{ts '2006-09-01 12:00:00.000'},{ts '2007-12-12 00:00:00.000'},0.8791285,1,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (16,1,N'A',N'4th Floor Block & Refurbishment',{ts '2006-09-01 12:00:00.000'},{ts '2007-02-01 00:00:00.000'},0.9369369,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (17,1,N'A',N'Bio Medical Research Center & CRF',{ts '2007-03-02 00:00:00.000'},{ts '2007-07-04 00:00:00.000'},0.9193549,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (18,1,N'A',N'Blundell Ward Relocation Florence + Aston Key',{ts '2007-08-07 12:00:00.000'},{ts '2007-11-12 12:00:00.000'},0.6237113,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (19,1,N'A',N'Bostock Ward Replacement of Water Treatment Plant',{ts '2007-03-07 00:00:00.000'},{ts '2007-06-23 12:00:00.000'},0.8478261,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (20,1,N'A',N'Centralisation Health Record Storage',{ts '2007-06-22 00:00:00.000'},{ts '2007-11-12 00:00:00.000'},0.7832168,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (21,1,N'A',N'ENT & Audiology Suite Phase II',{ts '2006-12-31 12:00:00.000'},{ts '2007-03-10 00:00:00.000'},0.7591241,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (22,1,N'A',N'GLI Structural Monitoring & Repair',{ts '2007-02-12 12:00:00.000'},{ts '2007-05-09 12:00:00.000'},0.9189189,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (23,1,N'A',N'Pathology Labs (Phase 1A)',{ts '2007-04-02 00:00:00.000'},{ts '2007-10-23 00:00:00.000'},0.9509804,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (24,1,N'A',N'Pathology Labs (Phase 2)',{ts '2007-01-15 00:00:00.000'},{ts '2007-07-29 12:00:00.000'},0.9207161,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (25,1,N'A',N'Pathology: NW5 - CSR Haematology & CSR Labs',{ts '2007-04-09 00:00:00.000'},{ts '2007-09-05 00:00:00.000'},0.8892617,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (26,1,N'A',N'Pathology: Haematology Day Care Center Transfer (NW4 to GT4)',{ts '2006-10-19 00:00:00.000'},{ts '2007-01-12 00:00:00.000'},0.8510638,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (27,1,N'A',N'HDR',{ts '2007-06-01 00:00:00.000'},{ts '2007-09-03 00:00:00.000'},0.8510638,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (28,1,N'A',N'Kidney Treatment Center',{ts '2007-06-25 00:00:00.000'},{ts '2007-11-18 00:00:00.000'},0.7636986,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (29,1,N'A',N'Maternity Expansion Business Case',{ts '2006-11-09 12:00:00.000'},{ts '2007-04-06 00:00:00.000'},0.9364162,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (30,1,N'A',N'New Laminar Flow Theatre at Guy''s',{ts '2007-04-25 12:00:00.000'},{ts '2007-11-29 12:00:00.000'},0.8990825,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (31,1,N'A',N'North Wing Basement Entance - Phase 2',{ts '2007-09-07 00:00:00.000'},{ts '2007-11-30 00:00:00.000'},0.8869048,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (32,1,N'A',N'Paediatric Neurosciences Feasibility',{ts '2006-11-29 00:00:00.000'},{ts '2007-02-10 00:00:00.000'},0.9041096,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (33,1,N'A',N'Fluroscopy (Imaging 2) at St. Thomas',{ts '2007-01-24 00:00:00.000'},{ts '2007-06-08 12:00:00.000'},0.9483395,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (34,1,N'A',N'Interventional Radiology Suite (Imaging 3) at GT3 Phase 1',{ts '2007-06-17 00:00:00.000'},{ts '2007-12-12 00:00:00.000'},0.9185393,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (35,1,N'A',N'Interventional Radiology Suite (Imaging 3) at GT3 Phase 2',{ts '2007-08-12 00:00:00.000'},{ts '2007-12-01 12:00:00.000'},0.9237668,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (36,1,N'A',N'Imaging: Radiology Environment & Waiting Areas (Imaging 2) Phases 1 & 2',{ts '2006-11-27 12:00:00.000'},{ts '2007-01-25 12:00:00.000'},1,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (37,1,N'A',N'Imaging: Radiology Environment & Waiting Areas (Imaging 2) Phase 3',{ts '2006-12-21 00:00:00.000'},{ts '2007-01-09 00:00:00.000'},1,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (38,1,N'A',N'Relocation of Pharmacy Manufacturing & QC Laboratories',{ts '2007-06-07 12:00:00.000'},{ts '2007-08-20 12:00:00.000'},0.9324324,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (39,1,N'A',N'Samaritan Ward - Bone marrow transplant beds',{ts '2007-06-01 00:00:00.000'},{ts '2007-08-18 00:00:00.000'},0.948718,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (40,1,N'A',N'Sexual Health Relocation',{ts '2007-01-10 12:00:00.000'},{ts '2007-04-12 12:00:00.000'},1,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (41,1,N'A',N'St. Thomas HV Upgrade',{ts '2007-05-02 12:00:00.000'},{ts '2007-06-20 12:00:00.000'},0.5204082,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (42,1,N'A',N'Ultrasound (Imaging 2) at Guy''s',{ts '2007-06-05 12:00:00.000'},{ts '2007-06-22 12:00:00.000'},1,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (43,1,N'F',N'New Schemes Approved in Year',{ts '2006-11-15 12:00:00.000'},{ts '2007-09-04 12:00:00.000'},0.7810035,1,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (44,2,N'A',N'Modular Theatres',{ts '2006-11-15 12:00:00.000'},{ts '2007-01-01 12:00:00.000'},0.8404256,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (45,2,N'A',N'ECH - Theatre Ventilation',{ts '2006-12-24 00:00:00.000'},{ts '2007-09-04 12:00:00.000'},0.7721022,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (46,2,N'A',N'Modular Pharmacy Aseptic Unit',{ts '2006-12-22 12:00:00.000'},{ts '2007-01-28 12:00:00.000'},0.8243243,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (47,2,N'A',N'Acute Stroke Unit Bid',{ts '2007-04-11 00:00:00.000'},{ts '2007-07-20 00:00:00.000'},0.745,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (48,2,N'A',N'Chemo Centralisation',{ts '2006-12-26 00:00:00.000'},{ts '2007-03-30 00:00:00.000'},0.9095744,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (49,2,N'A',N'Feasability of MRI at Guy''s',{ts '2007-05-12 00:00:00.000'},{ts '2007-07-25 00:00:00.000'},0.5945946,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (50,0,N'F',N'Engineering',{ts '2006-10-17 00:00:00.000'},{ts '2007-09-15 12:00:00.000'},0.708832,1,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (51,1,N'A',N'Borough Wing Theatre Ductwork and Heater Batteries',{ts '2007-05-02 00:00:00.000'},{ts '2007-06-20 00:00:00.000'},0.8571429,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (52,1,N'A',N'Combined Heat and Power System at Guy''s',{ts '2007-01-20 12:00:00.000'},{ts '2007-04-15 12:00:00.000'},0.8823529,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (53,1,N'A',N'Combined Heat and Power System at St. Thomas',{ts '2007-03-10 12:00:00.000'},{ts '2007-09-15 12:00:00.000'},0.7486773,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (54,1,N'A',N'Electrical Power Monitoring',{ts '2006-11-20 00:00:00.000'},{ts '2007-08-22 12:00:00.000'},0.8892922,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (55,1,N'A',N'Guy''s Lifts 101-105 (Guys Tower)',{ts '2006-12-06 00:00:00.000'},{ts '2007-03-03 00:00:00.000'},0.8850574,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (56,1,N'A',N'Guy''s Lifts 110-114 (Guys Tower)',{ts '2007-05-15 12:00:00.000'},{ts '2007-07-01 12:00:00.000'},0.5,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (57,1,N'A',N'Motor Control Panel Refurbishment',{ts '2007-01-09 00:00:00.000'},{ts '2007-06-13 00:00:00.000'},0.7096774,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (58,1,N'A',N'North Wing / Lambeth Wing Air Supply Plants',{ts '2007-01-13 00:00:00.000'},{ts '2007-04-19 00:00:00.000'},0.2135417,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (59,1,N'A',N'North Wing Chiller Replacement',{ts '2007-01-09 00:00:00.000'},{ts '2007-06-16 00:00:00.000'},0.5,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (60,1,N'A',N'North Wing Replacement Generator',{ts '2006-12-10 12:00:00.000'},{ts '2007-06-11 00:00:00.000'},0.7616438,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (61,1,N'A',N'NW/LW Riser Refurbishment',{ts '2007-01-20 12:00:00.000'},{ts '2007-03-17 12:00:00.000'},0.5,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (62,1,N'A',N'Satchwell BMS Upgrade',{ts '2006-12-16 12:00:00.000'},{ts '2007-07-18 12:00:00.000'},0.9135514,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (63,1,N'A',N'St. Thomas Increase Standby Capacity - Phase 2',{ts '2007-01-02 00:00:00.000'},{ts '2007-06-18 00:00:00.000'},0.8023952,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (64,1,N'A',N'Substation 3 HV Works (St. Thomas)',{ts '2007-02-27 00:00:00.000'},{ts '2007-08-10 12:00:00.000'},0.7872341,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (65,1,N'A',N'TB Electrical Distribution',{ts '2006-10-17 00:00:00.000'},{ts '2007-06-29 12:00:00.000'},0.7324324,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (66,1,N'A',N'Tower Wing Dental Theatre Air Handling Unit',{ts '2006-12-30 12:00:00.000'},{ts '2007-03-24 12:00:00.000'},0.75,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (67,1,N'A',N'Tower Wing Recovery Air Handling Unit',{ts '2007-03-02 00:00:00.000'},{ts '2007-08-08 00:00:00.000'},0.7075472,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (68,1,N'A',N'Water Booster Pumps - Phase 1 & 2',{ts '2007-01-08 12:00:00.000'},{ts '2007-06-14 12:00:00.000'},0.6433121,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (69,1,N'A',N'Water Softner - Boiler House',{ts '2007-02-12 12:00:00.000'},{ts '2007-07-30 12:00:00.000'},0.6666667,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (70,1,N'A',N'Energy Efficiency',{ts '2007-03-31 12:00:00.000'},{ts '2007-09-04 12:00:00.000'},0.7261146,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (71,0,N'F',N'PEAT Plan',{ts '2006-11-05 00:00:00.000'},{ts '2008-01-21 00:00:00.000'},0.8212748,1,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (72,1,N'A',N'Hilliers Ward Refurb St. Thomas',{ts '2007-03-28 00:00:00.000'},{ts '2007-05-23 12:00:00.000'},0.7964602,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (73,1,N'A',N'William Gull Ward St. Thomas',{ts '2007-03-20 00:00:00.000'},{ts '2007-08-23 00:00:00.000'},0.775641,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (74,1,N'A',N'Henry Ward Day Room',{ts '2007-04-29 00:00:00.000'},{ts '2007-06-01 00:00:00.000'},0.8030303,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (75,1,N'A',N'Sarah Swift Ward',{ts '2006-11-05 00:00:00.000'},{ts '2007-02-03 00:00:00.000'},0.7833334,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (76,1,N'A',N'Victoria Ward',{ts '2007-05-10 12:00:00.000'},{ts '2007-07-14 12:00:00.000'},0.9153846,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (77,1,N'A',N'Appointment Center Staff Toilets',{ts '2007-01-16 00:00:00.000'},{ts '2007-04-07 12:00:00.000'},0.7791411,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (78,1,N'A',N'Page Ward',{ts '2007-05-19 12:00:00.000'},{ts '2007-07-16 12:00:00.000'},0.7413793,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (79,1,N'A',N'Nightingdale Ward - Side Rooms',{ts '2007-02-18 00:00:00.000'},{ts '2007-04-28 00:00:00.000'},0.7753623,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (80,1,N'A',N'Luke Ward - Side Rooms',{ts '2007-11-14 12:00:00.000'},{ts '2007-12-31 12:00:00.000'},0.8085107,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (81,1,N'A',N'Therapies Department - Disabled Toilets',{ts '2007-07-31 12:00:00.000'},{ts '2007-09-26 12:00:00.000'},0.8157895,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (82,1,N'A',N'Northumberland Ward Side Rooms',{ts '2007-04-18 00:00:00.000'},{ts '2007-06-06 00:00:00.000'},0.8367347,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (83,1,N'A',N'General Outpatients',{ts '2007-10-17 00:00:00.000'},{ts '2008-01-21 00:00:00.000'},0.8697917,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (84,1,N'A',N'Rheumatology Clinic',{ts '2007-05-03 00:00:00.000'},{ts '2007-05-28 00:00:00.000'},0.84,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (85,1,N'A',N'Diabetes Clinic',{ts '2007-01-08 12:00:00.000'},{ts '2007-03-18 12:00:00.000'},0.8623188,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (86,1,N'A',N'ENT Clinic',{ts '2007-04-14 12:00:00.000'},{ts '2007-10-28 12:00:00.000'},0.9162437,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (87,0,N'F',N'Buildings Improvement Programs',{ts '2006-10-18 12:00:00.000'},{ts '2007-10-28 00:00:00.000'},0.7534721,1,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (88,1,N'F',N'Environmental Improvement Plan',{ts '2006-10-18 12:00:00.000'},{ts '2007-10-28 00:00:00.000'},0.7534721,0,0);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (89,2,N'A',N'Ward Improvementrs',{ts '2006-10-18 12:00:00.000'},{ts '2007-10-15 12:00:00.000'},0.6118785,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (90,2,N'A',N'Outpatient / Clinics',{ts '2006-12-29 00:00:00.000'},{ts '2007-08-11 00:00:00.000'},0.7422222,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (91,2,N'A',N'Circulation Areas',{ts '2007-04-14 12:00:00.000'},{ts '2007-10-28 00:00:00.000'},0.7430025,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (92,2,N'A',N'St. Thomas Main Entrance',{ts '2007-02-28 00:00:00.000'},{ts '2007-06-08 00:00:00.000'},0.765,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (93,2,N'A',N'St. Thomas Retail Mall',{ts '2007-01-01 00:00:00.000'},{ts '2007-02-06 00:00:00.000'},0.8194444,0,1);
INSERT INTO dbo.tb_GuysStThomas ([lTaskID],[lDepth],[sTaskType],[sDescription],[dtStartDate],[dtEndDate],[fPercentCompleted],[bSummary],[bHasTasks]) VALUES (94,2,N'A',N'Guys Main Entrance Revolving Door',{ts '2007-03-28 12:00:00.000'},{ts '2007-04-25 12:00:00.000'},0.8392857,0,1);
SET IDENTITY_INSERT dbo.tb_GuysStThomas OFF;