Как в календарном отчёте суммировать строку?

Question

[Константин Цветков]

Календарный отчёт:

Представление данных для отчёта:

CREATE VIEW ReportEncyclPublicLastCount
AS
  SELECT [Year], [Month], [MonthName], [MonthEnd],
         [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14], [15], [16], 
         [17], [18], [19], [20], [21], [22], [23], [24], [25], [26], [27], [28], [29], [30], [31]
    FROM 
      ( SELECT YEAR(PublicationLast) AS [Year], 
               MONTH(PublicationLast) AS [Month],
               DATENAME(MONTH, PublicationLast) AS [MonthName],
               DAY(EOMONTH(PublicationLast)) AS [MonthEnd],
               DAY(PublicationLast) AS [Day]
          FROM EncyclPage ) AS enDay
    PIVOT ( COUNT([Day])
     FOR [Day] IN ( [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14], [15], [16], 
                 [17], [18], [19], [20], [21], [22], [23], [24], [25], [26], [27], [28], [29], [30], [31])
          ) AS enPivot

Сумма по строке — вычисляемое поле на клиенте.
Как получить сумму на стороне сервера?

Answer 1

[Boris Köln]

SELECT [1] + [2] + [3] ... AS [MonthSum], ...
В случае null-значений добавьте COALESCE