Remove duplicate fields and have them null
Is there anyway to remove the duplicate rows and just have blank fields like below? Thanks.
Have:
Want:
Final Join:
SELECT DISTINCT MST_VISITS.ID_NUM
,MST_VISITS.MST_PROVIDER
,MST_VISITS.ADMIT_DATE
,MST_VISITS.LAST_VISIT
,MST_VISITS.TOTAL_UNITS
,LESS_7_SUMMARY.PROVIDER_NAME AS LESS_7_PROVIDER_NAME
,LESS_7_SUMMARY.SERVICE AS LESS_7_SERVICE
,LESS_7_SUMMARY.VISITS AS LESS_7_VISITS
--,BETWEEN_8_30_SUMMARY.PROVIDER_NAME AS BETWEEN_8_30_PROVIDER_NAME
--,BETWEEN_8_30_SUMMARY.SERVICE AS BETWEEN_8_30_SERVICE
--,BETWEEN_8_30_SUMMARY.VISITS AS BETWEEN_8_30_VISITS
,BETWEEN_31_180_SUMMARY.PROVIDER_NAME AS BETWEEN_31_180_PROVIDER_NAME
,BETWEEN_31_180_SUMMARY.SERVICE AS BETWEEN_31_180_SERVICE
,BETWEEN_31_180_SUMMARY.VISITS AS BETWEEN_31_180_VISITS
,BETWEEN_181_365_SUMMARY.PROVIDER_NAME AS BETWEEN_181_365_PROVIDER_NAME
,BETWEEN_181_365_SUMMARY.SERVICE AS BETWEEN_181_365_SERVICE
,BETWEEN_181_365_SUMMARY.VISITS AS BETWEEN_181_365_VISITS
--,PRIOR_180_SUMMARY.PROVIDER_NAME AS PRIOR_180_PROVIDER_NAME
--,PRIOR_180_SUMMARY.SERVICE AS PRIOR_180_SERVICE
--,PRIOR_180_SUMMARY.VISITS AS PRIOR_180_VISITS
--,ROW_NUMBER() OVER (PARTITION BY MST_VISITS.ID_NUM ORDER BY MST_VISITS.ADMIT_DATE) AS RN
FROM MST_VISITS
LEFT JOIN LESS_7_SUMMARY ON MST_VISITS.ID_NUM = LESS_7_SUMMARY.ID_NUM
--LEFT JOIN BETWEEN_8_30_SUMMARY ON MST_VISITS.ID_NUM = BETWEEN_8_30_SUMMARY.ID_NUM
LEFT JOIN BETWEEN_31_180_SUMMARY ON MST_VISITS.ID_NUM = BETWEEN_31_180_SUMMARY.ID_NUM
LEFT JOIN BETWEEN_181_365_SUMMARY ON MST_VISITS.ID_NUM = BETWEEN_181_365_SUMMARY.ID_NUM

