Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
Select Employee.ID, LastName + FirstName as empName SUM(CASE WHEN wh.Regular Is Not Null THEN wh.Regular Else '0.0' END) SUM(CASE WHEN wh.OverTime Is Not Null THEN wh.OverTime Else '0.0' END) From Employees LEFT OUTER JOIN EmployeeHours as wh on Employee.ID = wh.EmpID Where WeekEnding = @WeekEnding Group By Employee.ID, LastName, FirstName Order By wh.Regular desc, wh.OverTime desc, empName asc END
|Remove extra commas from beginning of string||5||37|
|SQL Server 2000: == Linked Server, With higher version ==||16||63|
|Need help creating a stored procedure||4||47|
|Updating statistics with error notification email in SQL server||4||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!