Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
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
|How to use TOP 1 in a T-SQL sub-query?||14||41|
|SSRS page break on parameter values||1||38|
|Need help debbuging stored procedure||21||34|
|How to write a sql query returning a result with my date time template?||8||32|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!