I have this query:

        SELECT fksiteID, SUM(SearchTypePerson) + 
           SUM(SearchTypeLocker) + 
           SUM(SearchTypeSpotRandom) + 
           SUM(SearchTypePersVehicle) + 
           SUM(SearchTypeVisitorContractorVehicle) + 
           SUM(SearchTypeCompanyVehicle) + 
           SUM(SearchTypeToilet) + 
           SUM(PatrolExternal) + 
           SUM(PatrolCarPark) + 
           SUM(PatrolPerimeter) + 
           SUM(PatrolInternal) + 
           SUM(VehicleCheckAmbientLine) + 
           SUM(VehicleCheckFridgeLine) + 
           SUM(VehicleCheckSealChecks) + 
           SUM(OtherChecksIDCards) + 
           SUM(OtherChecksIncidentReports) + 
           SUM(OtherChecksColdStoreChecks) AS NumChecks
      FROM [AIP].[dbo].[AAHOfficerDailyActivityReport]
      WHERE MonthOfReport = 6 AND RecordIsDeletedYN = 0 AND fkSiteID in (945,947,948,949,950,951,952)
      GROUP BY fkSiteID

Which gives this result:

    fksiteID	NumChecks
    945	        228
    947	        27
    949	        58
    951	        67
    952	        1015

However I want it to return:

    fksiteID	NumChecks
    945	        228
    947	        27
    948         0
    949	        58
    950         0
    951	        67
    952	        1015

I looked on Stack Exchange and use of the NULLIF function seems like it may be helpful but I can't get it to work with this query.

Any help appreciated.

Graham Sivill