Adding up of two column

Databases
1

In below query I want to add a column which gives total hours = RegHours+ OtHours, Can someone help how to add it and insert it in correct place ??

(SELECT EmployeeId 'EmpId',
		
		LaborLevelName 'Employeetype',
                PERSONFULLNAME  'Employee',
                laborlevel1 "Dept",
                laborlevel 2 "Shift",
                ROUND(SUM(TimeInSeconds/3600.00),2) 'Hours',
		ROUND(SUM(WageAmount),2) 'Earnings'
FROM Totals
WHERE ApplyDate BETWEEN from_timeframe AND to_timeframe AND 
PayCodeName = 'Regular'
GROUP BY EmployeeId, LaborLevelName4,LaborLevelName2, LaborLevelDsc3, LaborLevelName6,PERSONFULLNAME,substring(laborlevelname4,1,6))
,
OT_Hours_Earnings AS 
(SELECT EmployeeId 'EmpId',
		LaborLevelName6 'Employeetype',
                substring(laborlevelname4,1,6) "Dept",
                ROUND(SUM(TimeInSeconds/3600.00),2) 'Hours',
		ROUND(SUM(WageAmount),2) 'Earnings'
FROM Vp_Totals
WHERE ApplyDate BETWEEN from_timeframe AND to_timeframe AND 
	  PayCodeName = 'Overtime 1.5'
GROUP BY EmployeeId, substring(laborlevelname4,1,6), LaborLevelName6,LaborLevelName2,LaborLevelName4)
,
Prem_Hours_Earnings AS 
(SELECT EmployeeId 'EmpId',
		LaborLevelName6 'Employeetype',
                substring(laborlevelname4,1,6) "Dept",
		ROUND(SUM(TimeInSeconds/3600.00),2) 'Hours',
		ROUND(SUM(WageAmount),2) 'Earnings'
FROM Vp_Totals
WHERE ApplyDate BETWEEN from_timeframe AND to_timeframe AND 
	  PayCodeName IN ('Prem 2nd 3rd AND', 'Prem OT2nd 3rd AND')
GROUP BY EmployeeId, substring(laborlevelname4,1,6), LaborLevelName6,LaborLevelName2,LaborLevelName4)

SELECT	home.Dept,
		
                             home.Employee,
		home.Hours 'RegHours',
		home.Earnings 'RegEarn',
		ISNULL(Ohe.Hours,0) 'OtHours',
		ISNULL(Ohe.Earnings,0) 'OtEarn',
		ISNULL(Phe.Hours,0) 'PremHours',
		ISNULL(Phe.Earnings,0) 'PremEarn'
FROM MyWtkEmployee My
LEFT JOIN Regular_Hours_Earnings Rhe ON Rhe.EmpId = My.EmployeeId
LEFT JOIN Ot_Hours_Earnings Ohe ON Ohe.EmpId = My.EmployeeId
LEFT JOIN Prem_Hours_Earnings Phe ON Phe.EmpId = My.EmployeeId
WHERE My.SessionId = @wtksessionid AND NOT(Rhe.Dept IN ('-',' ')) 
ORDER BY Rhe.Dept, Rhe.employeetype
2

i am sorry, that query cannot possibly work as is… it is broken

this right here will generate a syntax error –

GROUP BY EmployeeId , LaborLevelName4 , LaborLevelName2 , LaborLevelDsc3 , LaborLevelName6 , PERSONFULLNAME , substring(laborlevelname4,1,6)) , OT_Hours_Earnings AS (SELECT EmployeeId 'EmpId',

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.