...
| Code Block | ||||
|---|---|---|---|---|
| ||||
select Status, p.IsTrainingPost, count(*) as rc from [HEELIVE].[vwPost] as p where status = 'Current' and managingdeaneryletb IS NULL group by Status, p.IsTrainingPost |
| Status | IsTrainingPost | rc |
|---|---|---|
| Current | Unknown | 436 |
| Current | Yes | 8907 |
| Current | No | 9960 |
Current Posts with a NULL Managing Deanery by IsTrainingPost
Current Non Training Posts will NULL ManagingDeanery
Current Non Training Posts will NULL ManagingDeanery by ApprovedGradeName
The above case statement doesn't cater for the following 17 Managing Deaneries that are assigned to 9,256 Inactive Posts;
...