Query Relating Rows W/O A Corresponding Value
SELECT [ID Code], statusCode
  FROM dbo.Table AS t
  WHERE NOT EXISTS 
  (
    SELECT 1 FROM dbo.Table 
    WHERE [ID Code] = t.[ID Code]
    AND statusCode = 'A'
  )
  GROUP BY [ID Code], statusCode;