--WHERE center = t1.center AND tsr = t1.tsr AND appl = t1.appl AND listid = t1.listid

USE REPORTING
GO
DECLARE @daysback INT
SET @daysback = 10
SELECT t0.center, t0.tsr, t0.appl, t0.listid,
	SUM(CAST((t0.time_connect + t0.time_paused + t0.time_waiting + t0.time_deassigned
		+ t0.time_acw) AS DECIMAL(9,2)) / 3600.0) AS sum_totaltime,
	SUM(CAST(t0.time_connect AS DECIMAL(9,2)) / 3600.0) AS sum_connect, 
	SUM(CAST(t0.time_paused AS DECIMAL(9,2)) / 3600.0) AS sum_paused, 
	SUM(CAST(t0.time_waiting AS DECIMAL(9,2)) / 3600.0) AS sum_waiting, 
	SUM(CAST(t0.time_deassigned AS DECIMAL(9,2)) / 3600.0) AS sum_deassigned, 
	SUM(CAST(t0.time_acw AS DECIMAL(9,2)) / 3600.0) AS sum_acw
FROM tsktsrhst t0 
CROSS JOIN
	(
	SELECT center, tsr, appl, listid, call_date,
	CAST((time_connect + time_paused + time_waiting + time_deassigned + time_acw) AS DECIMAL(9,2))
		/ 3600.0 total_hours
	FROM tsktsrhst
	WHERE call_date >= (GETDATE() - @daysback)
	) t1  
WHERE t0.center = t1.center AND t0.tsr = t1.tsr AND t0.appl = t1.appl AND t0.listid = t1.listid AND 
	t0.call_date >= (GETDATE() - @daysback) AND --MAY BE REDUNDANT, JUST WANT TO TRIM RESULT SET
	t1.call_date <= t0.call_date --FOR CUMMULATIVE AGGREGATE, REFERENCED IN CROSS JOIN
  	--FOR SLIDING AGGREGATE, REFERENCED IN CROSS JOIN.
	AND t1.call_date BETWEEN
	(
	SELECT MIN(call_date) min_call_date 
	FROM	(
			SELECT TOP 50 call_date 
			FROM tsktsrhst 
			WHERE center = t1.center AND tsr = t1.tsr AND appl = t1.appl AND listid = t1.listid			ORDER BY call_date DESC
			) t2
	) 
	AND 
	(
	SELECT MAX(call_date) max_call_date
	FROM tsktsrhst
	WHERE center = t1.center AND tsr = t1.tsr AND appl = t1.appl AND listid = t1.listid
	) 
GROUP BY t0.center, t0.tsr, t0.appl, t0.listid
ORDER BY t0.center, t0.tsr, t0.appl, t0.listid