27,582
社区成员




CREATE View dbo.vw_Final WITH SCHEMABINDING
AS
SELECT id , SUM(Quantity) AS Quantity
FROM ( SELECT id, Quantity FROM Table1
UNION ALL
SELECT id, Quantity FROM Table2) AS T1
GROUP BY id
GO
CREATE UNIQUE CLUSTERED INDEX IDX_vw_Final_id
ON vw_Final(id);
GO
CREATE View dbo.vw_Final1 WITH SCHEMABINDING
AS
SELECT id, SUM(Quantity) AS Quantity
FROM Table1
GROUP BY id
GO
CREATE UNIQUE CLUSTERED INDEX IDX_vw_Final1_id
ON vw_Final1(id);
GO
CREATE View dbo.vw_Final2 WITH SCHEMABINDING
AS
SELECT id, SUM(Quantity) AS Quantity
FROM Table2
GROUP BY id
GO
CREATE UNIQUE CLUSTERED INDEX IDX_vw_Final2_id
ON vw_Final2(id);
GO
CREATE View dbo.vw_Final3 WITH SCHEMABINDING
AS
select isnull(a.id,b.id) 'id',
isnull(a.Quantity,0)+isnull(b.Quantity,0) 'Quantity'
from vw_Final1 a full join vw_Final2 b on a.id=b.id
GO
CREATE UNIQUE CLUSTERED INDEX IDX_vw_Final3_id
ON vw_Final3(id);
GO