Advertisement
Guest User

Untitled

a guest
Jun 21st, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.54 KB | None | 0 0
  1. SELECT E.Firstname+' '+E.Lastname AS FullName,
  2.        ISNULL(CONVERT(varchar, CC.ReportSum), '0') + '/' +        
  3.        ISNULL(CONVERT(varchar, OC.ReportSum), '0') AS [Stats]
  4. FROM Employees AS E
  5. JOIN (SELECT EmployeeId,  COUNT(1) AS ReportSum
  6.       FROM Reports R
  7.       WHERE  YEAR(OpenDate) = 2016
  8.       GROUP BY EmployeeId) AS OC ON OC.Employeeid = E.Id
  9. LEFT JOIN (SELECT EmployeeId,  COUNT(1) AS ReportSum
  10.            FROM Reports R
  11.            WHERE  YEAR(CloseDate) = 2016
  12.            GROUP BY EmployeeId) AS CC ON CC.Employeeid = E.Id
  13. ORDER BY FullName
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement