Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Current Non Training Posts will NULL ManagingDeanery by ApprovedGradeName

Current Posts with NULL managingdeaneryletb and IsTrainingPost in ('No','Unknown') group by nationalPostNumber, MainSiteName and LocalOfficeName

Current Posts and IsTrainingPost = 'No' and SUBSTRING(nationalPostNumber, 1,3) = 'RK9' and MainSiteName = 'Derriford Hospital'

The above case statement doesn't cater for the following 17 Managing Deaneries that are assigned to 9,256 Inactive Posts;

...