SELECT
sum(a.Value) AS Value,
sum(a.Amount) AS Amount,
a.ChunkName AS ChunkName,
a.ChunkDate AS ChunkDate
INTO #ChunkAnswers
FROM #Answers AS a
GROUP BY a.ChunkName, a.ChunkDate
;
SELECT
sum(q.Value) AS Value,
sum(q.Amount) AS Amount,
q.ChunkName AS ChunkName,
q.ChunkDate AS ChunkDate
INTO #ChunkQuestions
FROM #Questions AS q
GROUP BY q.ChunkName, q.ChunkDate
;