below is my insert Script
drop table Temp_TestMethods
go
drop table Temp_ParallelMethods
go
create table Temp_TestMethods(
Id int IDENTITY (1,1),
TestMethod varchar(50),
EstimatedTime int
)
insert into Temp_TestMethods (TestMethod,EstimatedTime) values('T102',65)
insert into Temp_TestMethods values('T103',90)
insert into Temp_TestMethods values('T109',45)
insert into Temp_TestMethods values('T9',40)
insert into Temp_TestMethods values('T10',60)
insert into Temp_TestMethods values('T202',80)
insert into Temp_TestMethods values('T201',70)
insert into Temp_TestMethods values('T203',35)
insert into Temp_TestMethods values('TX',180)
create table Temp_ParallelMethods(
TESTMethodID int,
parallelMethodId int
)
insert into Temp_ParallelMethods values(1,2)
insert into Temp_ParallelMethods values(1,3)
insert into Temp_ParallelMethods values(1,4)
insert into Temp_ParallelMethods values(1,5)
insert into Temp_ParallelMethods values(2,1)
insert into Temp_ParallelMethods values(2,3)
insert into Temp_ParallelMethods values(2,4)
insert into Temp_ParallelMethods values(2,5)
insert into Temp_ParallelMethods values(3,2)
insert into Temp_ParallelMethods values(3,1)
insert into Temp_ParallelMethods values(3,4)
insert into Temp_ParallelMethods values(3,5)
insert into Temp_ParallelMethods values(4,2)
insert into Temp_ParallelMethods values(4,3)
insert into Temp_ParallelMethods values(4,1)
insert into Temp_ParallelMethods values(4,5)
insert into Temp_ParallelMethods values(5,2)
insert into Temp_ParallelMethods values(5,3)
insert into Temp_ParallelMethods values(5,4)
insert into Temp_ParallelMethods values(5,1)
insert into Temp_ParallelMethods values(6,7)
insert into Temp_ParallelMethods values(6,8)
insert into Temp_ParallelMethods values(7,6)
insert into Temp_ParallelMethods values(7,8)
insert into Temp_ParallelMethods values(8,6)
insert into Temp_ParallelMethods values(8,7)
select * from Temp_TestMethods
select * from Temp_ParallelMethods
I need to calculate total Estimatedtime in for Tests 'T1O3' and 'T102' and T109 and 'TX'
considering all parallel test to be beforemd at the same time. this should be only 1 record.
Test TX does not have any parallel methods so it will be addition to the rest of parallel test with max estimated time,