|
USE [EnVisage]
|
|
GO
|
|
|
|
ALTER VIEW [dbo].[VW_ScenarioActualsTotalCost] AS
|
|
SELECT A.ForecastScenarioId, A.ActualsScenarioId, SUM(A.Cost) AS TotalCost, SUM(A.Quantity) TotalQuantity
|
|
FROM VW_ScenarioPseudoActuals A
|
|
GROUP BY A.ForecastScenarioId, A.ActualsScenarioId
|
|
|
|
GO |