CREATE VIEW dbo.S1TERZI
AS
SELECT     SUM(CTV) AS controvalore, RETE
FROM         C6Mart.PATRIMONIO_TERZI
GROUP BY RETE