# MS SQL Count and Case statements not working

**URL:** <https://forum.inductiveautomation.com/t/ms-sql-count-and-case-statements-not-working/23784>\
**Category:** Ignition\
**Created:** [April 2, 2019, 1:33pm UTC](https://forum.inductiveautomation.com/t/ms-sql-count-and-case-statements-not-working/23784 "2019-04-02T13:33:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![EEdmondson](https://avatars.discourse-cdn.com/v4/letter/e/41988e/32.png) [@EEdmondson](https://forum.inductiveautomation.com/u/EEdmondson)\
**Post date:** [April 2, 2019, 1:33pm UTC](https://forum.inductiveautomation.com/t/ms-sql-count-and-case-statements-not-working/23784/1 "2019-04-02T13:33:19Z")

</div>

```auto
	count(case when Telesis_Stamp='' then null else 1 end) as Passed,
		count(case when Telesis_Stamp='' then 1 else null end) as Failed,
	count(*) as Total
FROM PartData_GKN05_C
WHERE Infeed_Pick_Time >= DATEADD(day,-7, GETDATE()) 
ALTER TABLE PartData_GKN05_C Add Total_Passed_Remeasures int
ALTER TABLE PartData_GKN05_C Add Total_Good_Parts int
ALTER TABLE PartData_GKN05_C Add Total_Rejects int
ALTER TABLE PartData_GKN05_C Add Total_Failed_Remeasures int

```

If I remove the count statements, the error goes away…

![Error](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4ce24e71ab72a891aa170a8ece2d243f61fe351f.png)

---

<div class="post-metadata">

**Author:** ![Sanderd17](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sanderd17/32/8735_2.png) [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\
**Post date:** [April 2, 2019, 1:43pm UTC](https://forum.inductiveautomation.com/t/ms-sql-count-and-case-statements-not-working/23784/2 "2019-04-02T13:43:14Z")

</div>

When you include `COUNT(*)` statements, you make a summary (aggregate) over different rows.

For this to have a meaning, you should aggregate over all columns at once, or group them by certain columns (f.e. group a count by article, to have a number of items for an article).

If you don’t aggregate and don’t group by a column, it makes no sense to include the column in your query.

This is a generic SQL error, nothing Ignition specific. See also [https://stackoverflow.com/questions/18258704/sql-server-column-invalid-in-the-select-list-because-it-is-not-contained-in-e](https://stackoverflow.com/questions/18258704/sql-server-column-invalid-in-the-select-list-because-it-is-not-contained-in-e) for example.

PS. please write your code in triple backquotes for clarity.