在SQL中创建动态SUM列

您可以使用窗口功能：

SELECt EU.[STORE NO], EU.REGION,       SUM(SA.SALESEXVAT) AS STORE_SALES       SUM(SUM(SA.SALESEXVAT)) OVER (PARTITION BY EU.REGION) as REGION_STORE_SALESFROM [BHXSQL2014-DEV].BManalytics.dbo.EUactivestores EU INNER JOIN      EUUKSQL01.dashboard.dbo.stocksalesaggregateweek sa       ON eu.[Store No] = sa.[branchno] WHERe sa.Fiscalyear  =     2016GROUP BY EU.[Store No], EU.REGION ;