WITH cteSampleData AS
(
SELECT '20160901' AS [sampleDate], 24 AS [1], 16 AS [2], 09 AS [3], 02 AS [4], 20 AS [5] UNION ALL
SELECT '20160902' AS [sampleDate], 31 AS [1], 20 AS [2], 11 AS [3], 06 AS [4], 16 AS [5] UNION ALL
SELECT '20160903' AS [sampleDate], 31 AS [1], 24 AS [2], 10 AS [3], 04 AS [4], 06 AS [5] UNION ALL
SELECT '20160904' AS [sampleDate], 38 AS [1], 21 AS [2], 11 AS [3], 02 AS [4], 25 AS [5] UNION ALL
SELECT '20160905' AS [sampleDate], 40 AS [1], 21 AS [2], 11 AS [3], 03 AS [4], 29 AS [5] UNION ALL
SELECT '20160906' AS [sampleDate], 40 AS [1], 19 AS [2], 11 AS [3], 02 AS [4], 04 AS [5] UNION ALL
SELECT '20160907' AS [sampleDate], 42 AS [1], 22 AS [2], 08 AS [3], 04 AS [4], 02 AS [5] UNION ALL
SELECT '20160908' AS [sampleDate], 43 AS [1], 18 AS [2], 06 AS [3], 00 AS [4], 15 AS [5] UNION ALL
SELECT '20160909' AS [sampleDate], 30 AS [1], 18 AS [2], 08 AS [3], 08 AS [4], 12 AS [5] UNION ALL
SELECT '20160910' AS [sampleDate], 32 AS [1], 23 AS [2], 12 AS [3], 03 AS [4], 17 AS [5] UNION ALL
SELECT '20160911' AS [sampleDate], 40 AS [1], 25 AS [2], 09 AS [3], 01 AS [4], 08 AS [5] UNION ALL
SELECT '20160912' AS [sampleDate], 32 AS [1], 25 AS [2], 06 AS [3], 01 AS [4], 04 AS [5] UNION ALL
SELECT '20160913' AS [sampleDate], 37 AS [1], 33 AS [2], 10 AS [3], 03 AS [4], 09 AS [5] UNION ALL
SELECT '20160914' AS [sampleDate], 33 AS [1], 18 AS [2], 03 AS [3], 02 AS [4], 11 AS [5] UNION ALL
SELECT '20160915' AS [sampleDate], 34 AS [1], 16 AS [2], 09 AS [3], 03 AS [4], 14 AS [5] UNION ALL
SELECT '20160916' AS [sampleDate], 35 AS [1], 15 AS [2], 09 AS [3], 04 AS [4], 16 AS [5] UNION ALL
SELECT '20160917' AS [sampleDate], 29 AS [1], 23 AS [2], 10 AS [3], 02 AS [4], 19 AS [5] UNION ALL
SELECT '20160918' AS [sampleDate], 39 AS [1], 20 AS [2], 10 AS [3], 04 AS [4], 12 AS [5] UNION ALL
SELECT '20160919' AS [sampleDate], 30 AS [1], 21 AS [2], 06 AS [3], 04 AS [4], 20 AS [5] UNION ALL
SELECT '20160920' AS [sampleDate], 36 AS [1], 20 AS [2], 09 AS [3], 03 AS [4], 25 AS [5] UNION ALL
SELECT '20160921' AS [sampleDate], 34 AS [1], 19 AS [2], 06 AS [3], 05 AS [4], 23 AS [5] UNION ALL
SELECT '20160922' AS [sampleDate], 31 AS [1], 25 AS [2], 01 AS [3], 04 AS [4], 21 AS [5] UNION ALL
SELECT '20160923' AS [sampleDate], 29 AS [1], 14 AS [2], 09 AS [3], 07 AS [4], 22 AS [5] UNION ALL
SELECT '20160924' AS [sampleDate], 44 AS [1], 16 AS [2], 09 AS [3], 04 AS [4], 16 AS [5] UNION ALL
SELECT '20160925' AS [sampleDate], 28 AS [1], 17 AS [2], 09 AS [3], 03 AS [4], 14 AS [5] UNION ALL
SELECT '20160926' AS [sampleDate], 44 AS [1], 23 AS [2], 07 AS [3], 05 AS [4], 17 AS [5] UNION ALL
SELECT '20160927' AS [sampleDate], 21 AS [1], 20 AS [2], 09 AS [3], 04 AS [4], 22 AS [5] UNION ALL
SELECT '20160928' AS [sampleDate], 38 AS [1], 29 AS [2], 08 AS [3], 05 AS [4], 23 AS [5] UNION ALL
SELECT '20160929' AS [sampleDate], 35 AS [1], 19 AS [2], 14 AS [3], 02 AS [4], 25 AS [5] UNION ALL
SELECT '20160930' AS [sampleDate], 02 AS [1], 06 AS [2], 08 AS [3], 04 AS [4], 05 AS [5]
)
SELECT 
	CAST([sampleDate] AS DATE) AS [sampleDate],
	[1],
	[2],
	[3],
	[4],
	[5],
	[1] + [2] + [3] + [4] + [5] AS total
FROM cteSampleData
ORDER BY [sampleDate]