below query hope your expectation
SELECT --EMP_NO, EMP_NAME
EMP_NO, EMP_NAME, R, [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],
([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])DUTY
FROM(
SELECT
EMP_NO, EMP_NAME, DEPT R
,CASE WHEN substring(DATENAME(WEEKDAY, Indatetime),1,3) <> 'SUN' and ATTENDANCE_STATUS = 1 THEN 'P'
WHEN ATTENDANCE_STATUS = 0 and substring(DATENAME(WEEKDAY, Indatetime),1,3) <> 'SUN' THEN 'A'
--else 'WO'
end ATTENDANCE
--,DATENAME(M, CHECKDATE)AS [MONTHVALUE]
,ISNULL(DAY(CHECKDATE),0) AS [DAYVALUE]
FROM EMPLOYEETIMESEQUENCE WHERE SUBSTRING(REPLACE(CONVERT(VARCHAR,CHECKDATE,106),' ','/'),4,8) = 'MAY/2019' and Emp_No = 1000) AS STUD
PIVOT
(
COUNT([ATTENDANCE])
FOR [DAYVALUE] 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 PV;