CREATE VIEW [dbo].[DeliverableProgress]
WITH SCHEMABINDING
AS
    SELECT
        M.DeliverableID,
        IIF(
            ISNULL(SUM(M.MilestoneWeight * MP.EventValue) / 100, 0) <= 100,
            ISNULL(SUM(M.MilestoneWeight * MP.EventValue) / 100, 0),
            100
        ) AS CurrentProgress,
        --- Just to make Index View happy, I have to add a COUNT_BIG. It does nothing.
        COUNT_BIG(*) AS CNT
    FROM dbo.Milestones M
    INNER JOIN dbo.Events MP ON (MP.MilestoneID = M.MilestoneID OR MP.EventID =151604)
        AND MP.EventTypeID = 9
        AND MP.IsActive = 1
        AND MP.IsCurrentProgress = 1
    WHERE M.IsActive = 1
    GROUP BY M.DeliverableID
GO

CREATE UNIQUE CLUSTERED INDEX IX_DeliverableProgress
    ON [dbo].[DeliverableProgress] ([DeliverableID])