nhsengland / MHSDS

This repo contains the SQL code used in NHS England's routine reporting from the MHSDS
MIT License
29 stars 9 forks source link

Update STAGING_CDP_I_IPS.sql #11

Closed John-Middlewick closed 5 months ago

John-Middlewick commented 5 months ago

Changes made to provider name allocation an providing third option of using provider name from [NHSE_Sandbox_MentalHealth].[dbo].[Dashboard_IPS_rebuild] in coalesce after gaps in data identified. Lines 86 and 111