...
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
select CASE WHEN TrustName IS NULL THEN 'NULL' ELSE 'NOT NULL' END TrustName, CASE WHEN trustNumber IS NULL THEN 'NULL' ELSE 'NOT NULL' END trustNumber, status, count(*) from [HEELIVE].[vwTrust] group by CASE WHEN TrustName IS NULL THEN 'NULL' ELSE 'NOT NULL' END, CASE WHEN trustNumber IS NULL THEN 'NULL' ELSE 'NOT NULL' END, status |
| TrustName | trustNumber | status | RowCount |
|---|---|---|---|
| NOT NULL | NOT NULL | Current | 824 |
| NULL | NULL | Current | 3 |
| NULL | NOT NULL | Current | 19 |
| NOT NULL | NULL | Current | 15 |
| NOT NULL | NULL | Inactive | 107 |
| NULL | NULL | Inactive | 6 |
| NULL | NOT NULL | Inactive | 22 |
| NOT NULL | NOT NULL | Inactive | 1273 |
| Total | 2269 |
There are 19 Trust rows that are duplicated
...