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 costcode, SUM(exthours) AS Expr1, CompanyId FROM Timesheets GROUP BY costcode, CompanyId
SELECT costcode,( SELECT SUM(exthours) from Timesheets where costcode = 'RTI') as RTITotal, (SELECT SUM(extHours) from Timesheets where costCode = 'NRT') AS NRTTOtal, CompanyId FROM Timesheets GROUP CompanyId
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL Server how to use a VARIABLE to link tables in a SQL Script?||3||41|
|t-sql left join||2||34|
|SQL 2008 - Find rows where only a specified field value exists for all rows with the same ID||7||19|
|Sql Query to return all values in Capital letters||2||17|
Join the community of 500,000 technology professionals and ask your questions.