m.nConnectionHandle = SQLCONNECT('TimeClockPlus')
cCostCode = '11708'
TEXT TO lcCmd noShow


SELECT TOP 100 PERCENT cast(dbo.EmployeeHours.EmployeeId as TinyInt) as EmployeeID, 
	RTRIM(dbo.EmployeeList.FirstName) + ' ' + RTRIM(dbo.EmployeeList.LastName) AS Name, 
	SUM(ROUND({ fn HOUR(dbo.EmployeeHours.TimeOut) } + CAST({ fn MINUTE(dbo.EmployeeHours.TimeOut) } AS DECIMAL) / 60, 2) 
	- ROUND({ fn HOUR(dbo.EmployeeHours.TimeIn) } + CAST({ fn MINUTE(dbo.EmployeeHours.TimeIn) } AS DECIMAL) / 60, 2)) AS Hours1
	
FROM   dbo.EmployeeHours INNER JOIN;
       dbo.EmployeeList ON dbo.EmployeeHours.EmployeeId = dbo.EmployeeList.EmployeeId
WHERE  (dbo.EmployeeHours.CostCode = ?cCostCode)
GROUP BY dbo.EmployeeHours.EmployeeId, RTRIM(dbo.EmployeeList.FirstName)+' '+RTRIM(dbo.EmployeeList.LastName)
ORDER BY dbo.EmployeeHours.EmployeeId,QueryName

ENDTEXT 

=SQLEXEC(m.nConnectionHandle,lcCmd)

BROWSE LAST NOWAIT

SQLDISCONNECT(m.nConnectionHandle)