Versions Compared

Old Version 11

changes.mady.by.user Russell Steel (Unlicensed)

Saved on

compared with

New Version 12

changes.mady.by.user Russell Steel (Unlicensed)

Saved on

Key

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

...

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

Dashboards Questions Pulses Data Reference New Question RS Current Posts managingdeaneryletb IS NULL and IsTrainingPost = 'No' and SUBSTRING(nationalPostNumber, 1,3) = 'NTH' and MainSiteName = 'Freeman Hospital'

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

...