Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT Employees.First_Name, Employees.Last_Name, SUM(Test.Credits_Earned) AS Credits, ROUND(SUM(Test.Credits_Earned) / 5, 0, 1) * 50 + ROUND(SUM(Test.Credits_Earned) / 10, 0, 1) * 50 AS AmountPaid FROM Employees INNER JOIN Test ON Employees.EmployeeID = Test.EmployeeID GROUP BY Employees.First_Name, Employees.Last_Name, Employees.EmployeeID HAVING (Employees.EmployeeID IS NOT NULL) AND (SUM(Test.Credits_Earned) > 0) ORDER BY Employees.First_Name, Employees.Last_Name
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Getting max record but maybe not use Group BY||2||36|
|Anyway to make these 2 SQL statements into one?||13||44|
|Subreport Parameter using default not what is passed.||4||31|
|SSRS 2008 Spanish Translation||8||21|