1 2 3 4 5 6 7 8 9 10 11 12
|
create table code
(
[Loader Boot_Initial baseline_Size LOC] [float] NULL,
[Loader Boot_Last baseline_Size LOC] [float] NULL,
[Loader Boot_Change_Size(LOC)Added] [float] NULL,
[Loader Boot_Change_Size(LOC)Deleted] [float] NULL,
[Loader Boot_Change_Size(LOC)Modified] [float] NULL,
[Loader Boot_Change_Size(LOC)Total Change] AS ((coalesce([Loader Boot_Change_Size(LOC)Added],(0))+coalesce([Loader Boot_Change_Size(LOC)Deleted],(0)))+coalesce([Loader Boot_Change_Size(LOC)Modified],(0))) PERSISTED,
[Loader Boot Effort Men*Days] [float] NULL,
[Loader Boot Ratio Added+Modified/Days] AS (CONVERT([decimal](8,2),([Loader Boot_Change_Size(LOC)Added]+[Loader Boot_Change_Size(LOC)Modified])/[Loader Boot Effort Men*Days],(0))) PERSISTED,
) |
Partager