快速判断测试前后的Codes是否是正确的

最新推荐文章于 2023-12-02 01:01:07 发布

最新推荐文章于 2023-12-02 01:01:07 发布 · 92 阅读

本文详细介绍了如何使用SQL查询语句对ICD代码进行处理，包括数据计数、ID对比以及重复项筛选，实现数据的高效管理和分析。

DECLARE @oldICD VARCHAR(MAX),@newICD VARCHAR(MAX) SET @oldICD ='250.30, 250.00, 250.02, 250.10, 250.12, 250.20, 250.22, 250.30, 250.32, 250.40, 250.42, 250.50, 250.52, 250.60, 250.62, 250.70, 250.72, 250.80, 250.82, 250.90, 250.92' SET @newICD ='250.00,250.02,250.10,250.12,250.20,250.22,250.30,250.32,250.40,250.42,250.50,250.52,250.60,250.62,250.70,250.72,250.80,250.82,250.90,250.92' SET @oldICD =REPLACE(REPLACE(REPLACE(REPLACE(@oldICD, CHAR(13), ''), CHAR(10), ''),CHAR(9),''),' ','') SET @newICD =REPLACE(REPLACE(REPLACE(REPLACE(@newICD, CHAR(13), ''), CHAR(10), ''),CHAR(9),''),' ','') SELECT 'New Count:'+convert(varchar(20),count(*)) FROM fn_Split(@newICD,',') SELECT 'Old Count:'+convert(varchar(20),count(*)) FROM fn_Split(@oldICD,',') SELECT id FROM fn_Split(@newICD,',') WHERE id NOT IN( SELECT id FROM fn_Split(@oldICD,',')) SELECT id FROM fn_Split(@oldICD,',') WHERE id NOT IN( SELECT id FROM fn_Split(@newICD,',')) SELECT id FROM fn_Split(@oldICD,',') group BY id HAVING COUNT(*)>1 SELECT id FROM fn_Split(@newICD,',') group BY id HAVING COUNT(*)>1