Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
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 s.id sId, l.id lId, count(c.ID) cCount, DATEPART (week,c.datetimereported) cReportedWeek, CASE WHEN l.liftshortname is Null THEN ' ** Site Level ** ' ELSE l.liftshortname END lLift FROM site s LEFT JOIN job j ON s.id = j.siteid INNER JOIN callout c ON j.id = c.jobid INNER JOIN jobline jl ON j.id = jl.jobid LEFT JOIN lift l ON jl.liftid = l.id WHERE ( c.datetimereported BETWEEN '01/01/2010' AND '12/12/2010' ) AND ( s.id IN (SELECT id FROM site s WHERE ( contractid = 3005 )) ) group by DATEPART (week,c.datetimereported), s.id, l.id, l.liftshortname
|running SQL 2012 SSIS packages in recent versions?||3||103|
|Highlight a field based on value in another field in SSRS||4||45|
|Updating statistics with error notification email in SQL server||4||109|
|sql 2012 cluster SSRS cluster aware||2||29|