INSERT INTO Dict_ReportItem ( RptItemCode, RptItemName, SpellCode, Unit, ValueFormat, SignFormat, Seq, FID, KeyNo, IsAddSummary, DefaultValue ) SELECT b.报告项目编码, b.报告项目名称, NULL, b.单位, NULL, NULL, NULL, c.ID, c.KeyNo, NULL, NULL FROM lis.rmlis6.dbo.v_xbdtj_sqxm a LEFT JOIN lis.rmlis6.dbo.v_xbdtj_bgxm b ON a.申请项目编码 = b.申请项目编码 LEFT JOIN vi_FeeItem c ON a.申请项目编码 = c.feeitemcode WHERE c.ItemClass = '检验' AND 报告项目编码 IS NOT NULL