search

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_M_MHSDS_Published.sql #10

Closed John-Middlewick closed 5 months ago

John-Middlewick commented 6 months ago

Additional Reporting_Period link added to prevent duplications LEFT JOIN (SELECT DISTINCT Org_Code, Organisation_Name, ICB_Code, Region_Code, Reporting_Period FROM [NHSE_Sandbox_Policy].[dbo].[REFERENCE_MHSDS_Submission_Tracker]) st on m.Org_Code = st.Org_Code and m.Reporting_Period=st.Reporting_Period