《公共卫生数据采集脚本修改内容》由会员分享，可在线阅读，更多相关《公共卫生数据采集脚本修改内容（1页珍藏版）》请在金锄头文库上搜索。
1、2017年2月27号修改内容该版本的脚本以马陆社区综管工程公共卫生的数据采集脚本为蓝本，编写的存储过程格式。一、 需要对脚本中的USE （下列图）进行修改或者直接删除|JSE ML_SQZG GO/* Object: StoredProcedure dbo.P_GGWS Script Date: 02/27/2017 09:08:13 */ SET ANS工_NULLS ON GOSET QUOTED_IDENTIFIER ON GO需要对FROM (下列图)后边的数据库链接进行修改，修改为本社区的数据库链接-GGWS_A_SMTJ60开具死亡医学推断书份数SET ZBBM = GGWS_A_
2、SMTJ601SELECT SQL= DELETE ZHGL_GGWS WHERE MONTH=+KSNY+ AND MONTH+JSNY+ AND ZBBM =1 1 EXEC(SQL)INSERT INTO ZHGL_GGWS(JGDM rJGMC ,YSDM ,YSMC ,ZBBM r ZBMC ,GRBM rYEAR ,MONTH zVALUE ,SCRQ) SELECT(SELECT CFGVALUE FROM SQZG_XTCS WHERE CFGCODE = 1QJCS_JGD14) AS JGDM, (SELECT CFGVALUE FROM SQZG_XTCS WHERE C
3、FGCODE = 1QJCS_JGMC1) AS JDMCr (SELECT DZHBH FROM JCSJ_SJDZ WHERE XT_XGRYGH = DZQBH) AS YSDM, (SELECT DZHMC FROM JCSJ_SJDZ WHERE XT_XGRYGH = DZQBH) AS YSMC, ZBBM AS ZBBM,(SELECT ZBMC FROM JCSJ_ZBDY WHERE ZBBM = ZBBM) AS ZBMC, ZJHM AS GRBM,YEAR(TBRQ) AS YEAR,SW DJXXCOUNT(*) AS VALUE, GETDATEQ AS SCRQ
4、|FROM ML QZJ G申S.DBO,CONVERT(VARCHAR(7)rTBRQ,120) AS MONTH,WHERE XT_JLZT = 0 -0正常,9删除AND BjLX = 1 -1死产推断书,2死广证明书,3死亡馥认书 AND XT XGJGDM LIKE ,310114106%习-公共卫生数娓库中本社区标ATW UUrJVir=KSNYAND CONVERT(VARCHAR(7)fTBRQ,120) =JSNYGROUP BY XT XGRYGH,ZJHM,YEAR(TBRQ)r CONVERTiVARCHAR(7)r TBRQ,120)需要对脚本中的机构代码（上图）进行修改，将机构代码修改为本社区在公共卫生数据库中的机构代码。
