INNER  JOIN
	(SELECT 
	PunchID, 
	SUM(RegularTime) as RT,  -- Past 40 hours needs to flow into overtime \ doubletime
	SUM(OverTime) as OverTime,
	SUM(DoubleTime) as DoubleTime ,  
            			-- This is where I am stuck. 
-- I am thinking of adding a case statement like the following:
                        (CASE 
				WHEN @RT <= 40 THEN @RT AS RegularTime
				WHEN @RT > 40 THEN ‘40’ AS RegularTime,  OverTime = OverTime+( OverTime-40)
			END)
	FROM
	WorkedHours 
        WHERE (WorkDate BETWEEN @WeekStarts AND @WeekEnds))
	) W ON E.PunchID = W.PunchID

INNER JOIN	(
			SELECT		PunchID, 
					CASE
						WHEN SUM(RegularTime) > 40 THEN 40
						ELSE SUM(RegularTime)
					END AS RT,  -- Past 40 hours needs to flow into overtime \ doubletime
					CASE
						WHEN SUM(RegularTime) > 40 THEN SUM(RegularTime) - 40
						ELSE 0
					END AS OverTime
			FROM		WorkedHours 
			WHERE		WorkDate BETWEEN @WeekStarts AND @WeekEnds
			GROUP BY	PunchID
	) W ON E.PunchID = W.PunchID

DECLARE   @WorkDate           datetime ='4/6/2009'

		set datefirst 7 
		DECLARE @WorkWeek int = DATEPART(WW,@WorkDate)
		DECLARE @WeekStarts datetime = DATEADD(WW,DATEDIFF(WW,0,@WorkDate),-1) 
		DECLARE @WeekEnds datetime = DATEADD(WW,DATEDIFF(WW,0,@WorkDate),5) 

		
		SELECT DISTINCT 
					(SELECT ADPCode FROM Company WHERE (Company.CompanyID = E.CompanyID)) AS [CO CODE], 
					@WorkWeek AS [BATCH ID],
					AR.ADP AS [FILE #], 
					'WorkWeek ' + CAST(@WorkWeek AS NVARCHAR)+ ' - ' + CAST(WorkDate AS NVARCHAR) AS [BATCH DESCRIPTION],
					E.FirstName + ' ' + E.LAStName AS [Employee Name], 
					'1' AS [Pay #],
					'' AS [Tax Frequency],
					W.RegularTime AS [Reg Hours],
					W.OverTime + W7.RegularTime7 AS [O/T Hours],
					W.DoubleTime + W7.OverTime7 +  W7.DoubleTime7 AS [Double Time],
					'' AS [Piece Work],
					'N' AS [Cancel Pay],
					'' AS [Adjust Ded Code]
					
		FROM Employee E 
		
			-- Join the WorkedHours table to sum the worked hours for the first 6 days
			INNER JOIN
				(SELECT 
				PunchID, 
				CASE
					WHEN SUM(RegularTime) > 40 THEN 40
					ELSE SUM(RegularTime)
				END AS RegularTime,  
				CASE
					WHEN SUM(RegularTime) > 40 THEN ((SUM(RegularTime) - 40) + SUM(OverTime))
					ELSE SUM(OverTime)
				END AS OverTime,

				SUM(DoubleTime) AS DoubleTime   
				FROM WorkedHours 
				WHERE (WorkDate BETWEEN @WeekStarts AND DATEADD(day, -1, @WeekEnds)) 
				GROUP BY PunchID
				) W ON E.PunchID = W.PunchID

			-- Join the WorkedHours table to sum the worked hours for the 7th day
			INNER  JOIN
				(SELECT 
					PunchID, 
					SUM(RegularTime) AS RegularTime7,  
					SUM(OverTime) AS OverTime7,
					SUM(DoubleTime) AS DoubleTime7   
				FROM WorkedHours 
				WHERE (WorkDate = CAST(@WeekEnds AS DATE)) 
				GROUP BY PunchID
				) W7 ON E.PunchID = W.PunchID
			
			-- Join the ADP_OS3_EmployeesRoster table to add the ADP Employee [File #]
			INNER  JOIN
			ADP_OS3_EmployeesRoster AR ON AR.SSN = E.SSN
			
			-- Rejoin the WorkedHours table to add the WorkDate
			INNER  JOIN
				(SELECT 
				PunchID, WorkDate
				FROM WorkedHours 
				WHERE (WorkDate BETWEEN @WeekStarts AND @WeekEnds) 
					
				) WD ON E.PunchID = WD.PunchID
						
		WHERE		(WorkDate BETWEEN @WeekStarts AND @WeekEnds) 
		Order by [FILE #]
		
		SELECT @WorkWeek AS WorkWeek, @WeekStarts AS WeekStarts, @WeekEnds AS WeekEnds