I have the following MSSQL query:
SELECT ModuleID, SUM(CASE ST80_Image_3_Complete When 0 THEN 1 else NULL end) AS CapCrimp
Group by moduleID
order by moduleID
This is an error counter (for a specific error) sorted by part number. I get a result set like this:
So here’s the question. Can I get this to exclude rows that have a sum of null?