Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
@ClientID UniqueIdentifier AS BEGIN SELECT tblEmployee.[EmployeeFirstName] as EmployeeFirstName, tblTask.[TaskName] as TaskName,SUM((SUM(tblTimesheet.Hours)* 60)+ SUM(tblTimesheet.Minutes)) as SumHours FROM tblTimesheet INNER JOIN tblEmployee ON tblTimesheet.EmployeeID = tblEmployee.EmployeeID INNER JOIN tblTask ON tblTimesheet.TaskID = tblTask.TaskID WHERE ClientID = @ClientID GROUP BY tblEmployee.[EmployeeFirstName], tblTask.[TaskName] ORDER BY tblEmployee.[EmployeeFirstName] ASC END
Join the community of 500,000 technology professionals and ask your questions.