1       11:52:59  Log started for: 接口数据导入
2       11:52:59  SQL Execute: MSSQL -  if not exists (select * from sysobjects where id = object_id(N'[dbo].[BA_DRRQ00]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
 create table [dbo].[BA_DRRQ00]                                          
(                                                                        
	[CZBZ00] [char] (1) NOT NULL ,      --操作标志'1' 导入'2'同步
       [DRRQ00] [datetime] NOT NULL ,       --导入日期                   
	[CZRQ00] [datetime] NOT NULL ,      --导入操作日期时间           
	[ZWXM00] [varchar] (20) NOT NULL    --导入人员姓名               
) ON [PRIMARY]                                                           

3       11:52:59  SQL Data In: MSSQL - Rows affected = 0
4       11:52:59  SQL Execute: MSSQL - select max(DRRQ00)DRRQ00,CZBZ00 from BA_DRRQ00 group by CZBZ00

5       11:53:06  SQL Execute: MSSQL -  select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_CREATE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1

6       11:53:06  SQL Execute: MSSQL -  if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_CREATE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) 
 drop procedure [dbo].[SP_IMP000_CREATE]
 if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_BM0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) 
 drop procedure [dbo].[SP_IMP000_BM0000]
 if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_ZY0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) 
 drop procedure [dbo].[SP_IMP000_ZY0000]
 if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_MZ0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) 
 drop procedure [dbo].[SP_IMP000_MZ0000]
 if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_GC0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) 
 drop procedure [dbo].[SP_IMP000_GC0000]
 if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_FZ0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) 
 drop procedure [dbo].[SP_IMP000_FZ0000]

7       11:53:06  SQL Data In: MSSQL - Rows affected = 0
8       11:53:06  SQL Execute: MSSQL - CREATE PROCEDURE [DBO].[SP_IMP000_CREATE]
AS
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRZYXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_BA_BRZYXX]
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRZDXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_BA_BRZDXX]
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRSSXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_BA_BRSSXX]
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRJSXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_BA_BRJSXX]
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRFYXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_BA_BRFYXX]
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BAYSXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_BA_BAYSXX]
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_YSXX00]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_BA_YSXX00]
     
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_MZRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_TJ_MZRSJ0]
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_ZYRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_TJ_ZYRSJ0]
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_GCRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_TJ_GCRSJ0]
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_FZRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_TJ_FZRSJ0]    
     
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_XT_YGBM00]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_XT_YGBM00]
  if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_XT_BMBM00]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
     drop table [dbo].[IMP_XT_BMBM00]

CREATE TABLE [DBO].IMP_BA_BRZYXX(
	LSH000		NUMERIC(10)	PRIMARY KEY 	,	--流水号
  CARDNO    VARCHAR(20)     NULL      , --
  ZYLSH0    VARCHAR(160)    NULL      , --住院流水号
  ZYID00    NUMERIC(12)     NULL      , --
	BAH000		VARCHAR(20)	NOT NULL	,	--病案号
	ZYCS00		NUMERIC(2)	NOT NULL	,	--住院次数
	ZYH000		VARCHAR(20)	NULL		,	--住院号
	BRXM00		VARCHAR(16)	NULL		,	--病人姓名
	BRXB00		VARCHAR(16)	NOT NULL	,	--病人性别
	BRCSRQ		DATETIME	NULL	        ,		--病人出生日期
	BRNL00		NUMERIC(6,3)	NULL		,	--病人年龄
	HYZK00		CHAR(6)		NULL		,	--婚姻状况
	ZY0000		CHAR(40)	NULL		,	--职业
	BRLY00		VARCHAR(18)	NULL		,	--病人来源
	CSSF00		CHAR(40)	NULL		,	--出生省份
	CSXS00		CHAR(40)	NULL		,	--出生县市
	MZ0000		CHAR(40)	NULL		,	--民族
	GJ0000		CHAR(30)	NULL		,	--国籍
	SFZH00		CHAR(20)	NULL		,	--身份证号
	GZDW00		VARCHAR(50)	NULL		,	--工作单位
	GZDH00		VARCHAR(20)	NULL		,	--单位电话
	GZYB00		CHAR(8)		NULL		,	--工作邮编
	JTDZ00		VARCHAR(50)	NULL		,	--家庭地址
	JTDH00		VARCHAR(20)	NULL		,	--家庭电话
	JTYB00		CHAR(8)		NULL		,	--家庭邮编
	LXRXM0		VARCHAR(16)	NULL		,	--联系人姓名
	LXRDZ0		VARCHAR(50)	NULL		,	--联系人地址
	LXRDH0		VARCHAR(20)	NULL		,	--联系人电话
	LXRGX0		CHAR(10)	NULL		,	--联系人关系
	ZDFS00		VARCHAR(10)	NULL		,	--诊断方式
	RYQK00		CHAR(8)		NOT NULL	,	--入院情况
	RYRQ00		DATETIME	NULL		,	--入院日期
	RYSJ00		CHAR(8)		NULL		,	--入院时间
	RYKB00		NUMERIC(6)	NULL		,	--入院科别
	RYKBMC		VARCHAR(20)	NULL		,	--入院科别名称
	RYBF00		CHAR(10)	NULL		,	--入院病房
	ZKKB00		CHAR(30)	NULL		,	--转科科别
	ZKKBMC		VARCHAR(40)	NULL		,	--转科科别名称
	CYRQ00		DATETIME	NOT NULL	,	--出院日期
	CYSJ00		CHAR(8)		NULL		,	--出院时间
	CYKB00		NUMERIC(6)	NOT NULL	,	--出院科别
	CYKBMC		VARCHAR(20)	NOT NULL	,	--出院科别名称
	CYBF00		CHAR(10)	NULL		,	--出院病房
	ZYTS00		NUMERIC(5)	NULL		,	--住院天数
	QZRQ00		DATETIME	NULL		,	--确诊日期
	BLZD00		VARCHAR(100)	NULL		,	--病理诊断
	GMYW00		VARCHAR(80)	NULL		,	--过敏药物
	HBSAG0		CHAR(6)		NULL		,	--HBSAG
	HCVAB0		CHAR(6)		NULL		,	--HCV-AB
	HIVAB0		CHAR(6)		NULL		,	--HIV-AB
	MZCYFH		CHAR(8)		NULL		,	--门诊与出院符合
	RYCYFH		CHAR(8)		NULL		,	--入院与出院符合
	SQSHFH		CHAR(8)		NULL		,	--术前术后符合
	LCBLFH		CHAR(8)		NULL		,	--临床与病理符合
	FSBLFH		CHAR(8)		NULL		,	--放射与病理符合
	QJCS00		NUMERIC(2)	NULL		,	--抢救次数
	CGCS00		NUMERIC(2)	NULL		,	--成功次数
	BAZL00		CHAR(4)		NULL		,	--病案质量
	SFSJ00		CHAR(4)		NULL		,	--是否尸检
	DYBL00		CHAR(2)		NULL		,	--手术、治疗、等为第一病例
	SFSZ00		CHAR(4)		NULL		,	--是否随诊
	SZQX00		VARCHAR(10)	NULL		,	--随诊期限
	SJBL00		CHAR(2)		NULL		,	--示教病历
	XX0000		VARCHAR(6)	NULL		,	--血型
	RH0000		VARCHAR(6)	NULL		,	--RH
	SXFY00		CHAR(2)		NULL		,	--输血反应
	HXB000		VARCHAR(15)	NULL		,	--输血品种 红细胞
	XXB000		NUMERIC(9,2)	NULL		,	--输血品种 血小板
	XJ0000		NUMERIC(9,2)	NULL		,	--输血品种 血浆
	QX0000		NUMERIC(9,2)	NULL		,	--输血品种 全血
	SXQT00		NUMERIC(9,2)	NULL		,	--输血品种 其他
	ZKRQ00		DATETIME	NULL		,	--质控日期
	BAZT00		CHAR(1)		NULL		,	--病案状态 0：借阅 1：
	SRRK00		CHAR(1)		NULL		,	--输入入口 0：卡片 1：首页
	LRRY00		NUMERIC(5)	NULL		,	--录入人员
	LRRYMC		VARCHAR(40)	NULL		,	--录入人员姓名
	LRRQ00		DATETIME	NULL		,	--录入日期
	JFFS00		VARCHAR(40)	NULL		,	--交费方式
	ZJE000		MONEY		NULL		,	--总费用
	BZ0000		VARCHAR(100)	NULL,			--备注
  
  JKDAH0  varchar(30) NULL ,   --居民健康档案号
  BRNLY0  numeric(5)  NULL ,    --病人年龄月
  BRNLR0  numeric(5)  NULL ,   --病人年龄日
  CSDS00  varchar(40) NULL ,  --出生地市
  JGSF00  varchar(40) NULL ,  --籍贯省份
  JGXS00  varchar(40) NULL ,  --籍贯县市
  YECSTZ  numeric(5)  NULL ,  --新生儿出生体重(克)
  YERYTZ  numeric(5)  NULL ,  --新生儿入院体重(克)
  XZZ000  varchar(60) NULL ,  --现住址
  XZZDH0  varchar(20) NULL ,  --现住址电话
  XZZYB0  varchar(10) NULL ,  --现住址邮编
  RYTJ00  varchar(30)  NULL ,  --入院途径名称 
  BLZDBM  VARCHAR(10) NULL ,  --病理诊断编码
  BLH000  varchar(30) NULL ,  --病理号
  SFYWGM  VARCHAR(10) NULL ,  --是否药物过敏
  LYFS00  varchar(50) NULL ,  --离院方式
  ZYYLJG  VARCHAR(50) NULL ,  --转院医疗机构
  ZZYJH0  CHAR(2)     NULL ,  --是否有出院31天内再住院计划
  ZZYMD0  VARCHAR(50) NULL ,  --出院31天内再住院计划目的地
  HMRYQD  numeric(5)  NULL ,  --颅脑损伤患者昏迷入院前天数
  HMRYQH  numeric(5)  NULL ,  --颅脑损伤患者昏迷入院前小时数
  HMRYQM  numeric(5)  NULL ,  --颅脑损伤患者昏迷入院前分钟数
  HMRYHD  numeric(5)  NULL ,  --颅脑损伤患者昏迷入院后天数
  HMRYHH  numeric(5)  NULL ,  --颅脑损伤患者昏迷入院后小时数
  HMRYHM  numeric(5)  NULL ,  --颅脑损伤患者昏迷入院后分钟数 	
  SSZDYY  VARCHAR(200) NULL,  --损伤、中毒外部原因
  SSZDBM  VARCHAR(50)  NULL   --损伤、中毒外部原因疾病编码
	)

--2.病人诊断信息表
CREATE TABLE [DBO].IMP_BA_BRZDXX(
	LSH000 		NUMERIC(10)	NOT NULL	,	--流水号
	ZDXH00		NUMERIC(10)	NOT NULL	,	--诊断序号
	ZDLB00		CHAR(1)		NOT NULL	,	--诊断类别
	JBBM00		VARCHAR(10)	NOT NULL	,	--疾病编码
	XHBM00		VARCHAR(10)	NOT NULL	,	--*编码
	JBMC00		VARCHAR(50)	NOT NULL	,	--疾病名称
	FZBM00		VARCHAR(10)	NULL		,	--辅助编码
	FZMC00		VARCHAR(50)	NULL		,	--辅助名称
	ZDRQ00		DATETIME	NULL		,	--诊断日期
	ZLXG00		VARCHAR(16)	NULL		,	--治疗效果
	SFYZ00		VARCHAR(8)	NULL		,	--是否疑诊
	M16800		VARCHAR(8)	NULL		,	--168编码	
        RYBQ00          VARCHAR(20)     NULL                    --入院病情(名称)	
	)

 CREATE TABLE [DBO].IMP_BA_BRSSXX(
	LSH000		NUMERIC(10)	NOT NULL	,	--流水号
	SSXH00		NUMERIC(2)	NOT NULL	,	--手术序号
	SSLB00		VARCHAR(4)	NOT NULL	,	--手术类别 1主手术 0副手术
	SSM000		VARCHAR(10)	NOT NULL	,	--手术码
	SSMC00		VARCHAR(50)	NOT NULL	,	--手术名称
	SSRQ00		DATETIME	NOT NULL	,	--手术日期
	SSSJ00		VARCHAR(8)	NULL		,	--手术时间
	SSZL00		VARCHAR(8)	NULL		,	--手术种类 大、中、小手术
	SSYS00		VARCHAR(30)	NULL		,	--手术医师
	SSYSMC		VARCHAR(40)	NULL		,	--手术医师名称
	IYS000		VARCHAR(30)	NULL		,	--I助医师
	IYSMC0		VARCHAR(40)	
9       11:53:06  SQL Data In: MSSQL - Rows affected = 0
10      11:53:06  SQL Execute: MSSQL - exec SP_IMP000_CREATE

11      11:53:07  SQL Data In: MSSQL - Rows affected = 0
12      11:53:07  SQL Execute: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_BM0000
AS
DECLARE @BMBH00  NUMERIC(6)
DECLARE @BH0000  VARCHAR(15)
DECLARE @BMMC00  VARCHAR(20)
DECLARE @BZCW00  NUMERIC(4)
DECLARE @SFYZ00  CHAR(1)
DECLARE @PYSM00  VARCHAR(10)
DECLARE @WBSM00  VARCHAR(10)
DECLARE @SBKB00  VARCHAR(6)
DECLARE @BMLB00  VARCHAR(16)
DECLARE @BMXZ00  CHAR(1)
DECLARE @SRRK00  CHAR(1)
DECLARE @SYBZ00  CHAR(1)
DECLARE @ZBFL00  CHAR(4)
DECLARE @TJXH00  NUMERIC(3)
DECLARE @MAXBH0  INT


DECLARE @XKH000	VARCHAR(16)
DECLARE @ZWXM00 VARCHAR(20)
DECLARE @XB0000 VARCHAR(10)
DECLARE @DLMM00 VARCHAR(40)
DECLARE @YGXZ00 CHAR(1)


--部门编码
DECLARE BMBM00_CURSOR CURSOR FOR 
	SELECT RTRIM(BMMC00),CASE RTRIM(BMXZ00) WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END,BZCW00 FROM IMP_XT_BMBM00
OPEN BMBM00_CURSOR
SELECT @MAXBH0=ISNULL(MAX(CONVERT(INT,SUBSTRING(BH0000,4,3))),0)+1 FROM XT_BMBM00 WHERE BH0000>'000' AND BH0000<='000999'
FETCH BMBM00_CURSOR INTO @BMMC00,@BMXZ00,@BZCW00
WHILE (@@FETCH_STATUS=0) BEGIN
	SELECT @TJXH00=MAX(TJXH00)+1 FROM XT_BMBM00
	IF NOT EXISTS(SELECT BMBH00 FROM XT_BMBM00 WHERE BMMC00=@BMMC00 AND BMXZ00=CASE @BMXZ00 WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END) BEGIN
		SET @BH0000='000'+RIGHT('000'+CONVERT(VARCHAR(3),@MAXBH0),3)
		SELECT @ZBFL00=CASE @BMXZ00 WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END
		SET @SFYZ00='0'
		SET @SBKB00='00'
		SELECT @BMLB00=CASE @BMXZ00 WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END
		SET @SRRK00='0'
		SET @SYBZ00='1'
		EXEC SP_XT_HZPYWB @BMMC00 , @PYSM00 OUTPUT , @WBSM00 OUTPUT
		INSERT INTO XT_BMBM00(
			BH0000,BMMC00,BZCW00,SFYZ00,PYSM00,WBSM00,
			SBKB00,BMLB00,BMXZ00,SRRK00,SYBZ00,ZBFL00,
			TJXH00)
		VALUES(
			@BH0000,@BMMC00,@BZCW00,@SFYZ00,@PYSM00,@WBSM00,
			@SBKB00,@BMLB00,@BMXZ00,@SRRK00,@SYBZ00,@ZBFL00,
			@TJXH00)
                SET @MAXBH0=@MAXBH0+1
	END	
	FETCH BMBM00_CURSOR INTO @BMMC00,@BMXZ00,@BZCW00
END
CLOSE BMBM00_CURSOR
DEALLOCATE BMBM00_CURSOR

--员工编码
DECLARE YGBM00_CURSOR CURSOR FOR
	SELECT RTRIM(XKH000),RTRIM(ZWXM00),RTRIM(XB0000) FROM IMP_XT_YGBM00 WHERE XKH000 IS NOT NULL
OPEN YGBM00_CURSOR
FETCH NEXT FROM YGBM00_CURSOR INTO @XKH000,@ZWXM00,@XB0000
WHILE (@@FETCH_STATUS=0) BEGIN
	IF NOT EXISTS(SELECT YGBH00 FROM XT_YGBM00 WHERE ZWXM00=@ZWXM00 AND XKH000=@XKH000) BEGIN
		SET @XB0000=CASE @XB0000 WHEN '男性' THEN '男' WHEN '女性' THEN '女' WHEN '' THEN '男' ELSE @XB0000 END
		SET @DLMM00='hplZOq6iScaqyo'
		SET @YGXZ00='9'
		SELECT TOP 1 @BMBH00=BMBH00 FROM XT_BMBM00 WHERE BH0000<>'000'
		EXEC SP_XT_HZPYWB @ZWXM00 , @PYSM00 OUTPUT , @WBSM00 OUTPUT
		SET @SYBZ00='1'
		INSERT INTO XT_YGBM00(
			XKH000,ZWXM00,XB0000,DLMM00,YGXZ00,BMBH00,
			PYSM00,WBSM00,SYBZ00)
		VALUES(
			@XKH000,@ZWXM00,@XB0000,@DLMM00,@YGXZ00,@BMBH00,
			@PYSM00,@WBSM00,@SYBZ00)
	END
	FETCH NEXT FROM YGBM00_CURSOR INTO @XKH000,@ZWXM00,@XB0000
END
CLOSE YGBM00_CURSOR
DEALLOCATE YGBM00_CURSOR




 
 
 
 
 
 
 
 
 
 
 

13      11:53:07  SQL Data In: MSSQL - Rows affected = 0
14      11:53:07  SQL Execute: MSSQL -  select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_BA0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1

15      11:53:07  SQL Execute: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_ZY0000 @FLAG00 CHAR(1)
AS
DECLARE @RQ0000	DATETIME	--日期
DECLARE @BMBH00	NUMERIC(6)	--部门编号       
DECLARE @BMMC00 VARCHAR(20)	--部门名称             
DECLARE @MJZRCS	INT		--门急诊人次数                
DECLARE @YYRS00	INT		--原有人数                    
DECLARE @CYBRS0	INT		--出院病人数                  
DECLARE @TQZYRS	INT		--同期住院人数                
DECLARE @RYRS00	INT		--入院人数                    
DECLARE @TKZR00	INT		--他科转入                    
DECLARE @CYBSQ0	INT		--本市、区                    
DECLARE @CYSQXC	INT		--其中：市区、县城            
DECLARE @CYSQJX	INT		--	市区郊县              
DECLARE @CYSQQT	INT		--	市区其他              
DECLARE @CYBS00	INT		--本省其他地区                
DECLARE @CYWS00	INT		--外省                        
DECLARE @CYGW00	INT		--国外                        
DECLARE @ZWTK00	INT		--转往他科                    
DECLARE @SYRS00	INT		--实有人数                    
DECLARE @PHRRS0	INT		--陪护人日数                  
DECLARE @WZRS00	INT		--危重人数                    
DECLARE @WZQJ00	INT		--危重抢救人数                
DECLARE @WZQJCG	INT		--危重抢救成功人数            
DECLARE @ZYRS00	INT		--治愈人数                    
DECLARE @HZRS00	INT		--好转人数                    
DECLARE @WYRS00	INT		--未愈人数                    
DECLARE @SWRS00	INT		--死亡人数                    
DECLARE @SW2400	INT		--其中24小时死亡人数          
DECLARE @QTHJ00	INT		--其他合计                    
DECLARE @ZCFMRS	INT		--其中：正常分娩人数          
DECLARE @JHSYRS	INT		--	计划生育人数
DECLARE @QTRS00	INT		--	其他人数              
DECLARE @ZLHJ00	INT		--肿瘤合计                    
DECLARE @EXZL00	INT		--其中：恶性肿瘤              
DECLARE @YWA000	INT		--	原位癌                
DECLARE @LXZL00	INT		--	良性肿瘤              
DECLARE @JJEXZL	INT		--	交界恶性肿瘤          
DECLARE @WZZL00	INT		--	动态未知肿瘤          
DECLARE @SSRCS0	INT		--手术人次数                  
DECLARE @WJSSLS	INT		--无菌手术例数                
DECLARE @WJGRLS	INT		--无菌感染例数                
DECLARE @SSQHFH	INT		--手术前后符合                
DECLARE @SQBKD0	INT		--术前不肯定数                
DECLARE @RCZDFH	INT		--入院与出院符合              
DECLARE @RCBKD0	INT		--入出不肯定数                
DECLARE @BLZDS0	INT		--病理诊断数                  
DECLARE @LCBLFH	INT		--临床病理符合数              
DECLARE @MCFH00	INT		--门诊与出院符合              
DECLARE @MCBKD0	INT		--门诊与出院不肯定            
DECLARE @FSBLFH	INT		--放射病理符合                
DECLARE @CYCF00	INT		--出院产妇                    
DECLARE @SWCF00	INT		--死亡产妇                    
DECLARE @XSES00	INT		--新生儿数                    
DECLARE @XSESWS	INT		--新生儿死亡数                
DECLARE @MZRS00	INT		--麻醉人数                    
DECLARE @MZSWRS	INT		--麻醉死亡人数                
DECLARE @SRQZS0	INT		--三日确诊数                  
DECLARE @ZYZLS0	INT		--中医治疗数                  
DECLARE @ZXYZLS	INT		--中西医治疗数                
DECLARE @YYGR00	INT		--医院感染数
DECLARE @BZCW00	INT		--编制床位
DECLARE @SYCW00	INT		--实有床位
DECLARE @SJKFCR	INT		--实际开放床日数
DECLARE @SJZYCR	INT		--实际占用床日数
DECLARE @CYZZYR	INT		--出院者占用床日数
DECLARE @ZYZZYR	INT		--治愈者占用床日数
DECLARE @LRRQ00	DATETIME	--录入日期
DECLARE @LRRY00	NUMERIC(5)	--录入人员

DECLARE @SJQSRQ DATETIME	--实际起始日期	
         
SELECT @LRRY00=YGBH00 FROM XT_YGBM00 WHERE ZWXM00='超级用户'
DECLARE ZYRSJ0_CURSOR CURSOR FOR 
	SELECT 
		RQ0000,BMBH00,MJZRCS,YYRS00,CYBRS0,TQZYRS,
		RYRS00,TKZR00,CYBSQ0,CYSQXC,CYSQJX,CYSQQT,
		CYBS00,CYWS00,CYGW00,ZWTK00,SYRS00,PHRRS0,
		WZRS00,WZQJ00,WZQJCG,ZYRS00,HZRS00,WYRS00,
		SWRS00,SW2400,QTHJ00,ZCFMRS,JHSYRS,QTRS00,
		ZLHJ00,EXZL00,YWA000,LXZL00,JJEXZL,WZZL00,
		SSRCS0,WJSSLS,WJGRLS,SSQHFH,SQBKD0,RCZDFH,
		RCBKD0,BLZDS0,LCBLFH,MCFH00,MCBKD0,FSBLFH,
		CYCF00,SWCF00,XSES00,XSESWS,MZRS00,MZSWRS,
		SRQZS0,ZYZLS0,ZXYZLS,YYGR00,BZCW00,SYCW00,
		SJKFCR,SJZYCR,CYZZYR,ZYZZYR,LRRQ00,BMMC00
	FROM IMP_TJ_ZYRSJ0
OPEN ZYRSJ0_CURSOR
FETCH ZYRSJ0_CURSOR INTO 
	@RQ0000,@BMBH00,@MJZRCS,@YYRS00,@CYBRS0,@TQZYRS,
	@RYRS00,@TKZR00,@CYBSQ0,@CYSQXC,@CYSQJX,@CYSQQT,
	@CYBS00,@CYWS00,@CYGW00,@ZWTK00,@SYRS00,@PHRRS0,
	@WZRS00,@WZQJ00,@WZQJCG,@ZYRS00,@HZRS00,@WYRS00,
	@SWRS00,@SW2400,@QTHJ00,@ZCFMRS,@JHSYRS,@QTRS00,
	@ZLHJ00,@EXZL00,@YWA000,@LXZL00,@JJEXZL,@WZZL00,
	@SSRCS0,@WJSSLS,@WJGRLS,@SSQHFH,@SQBKD0,@RCZDFH,
	@RCBKD0,@BLZDS0,@LCBLFH,@MCFH00,@MCBKD0,@FSBLFH,
	@CYCF00,@SWCF00,@XSES00,@XSESWS,@MZRS00,@MZSWRS,
	@SRQZS0,@ZYZLS0,@ZXYZLS,@YYGR00,@BZCW00,@SYCW00,
	@SJKFCR,@SJZYCR,@CYZZYR,@ZYZZYR,@LRRQ00,@BMMC00
WHILE (@@FETCH_STATUS=0) BEGIN
	IF EXISTS(SELECT BMBH00 FROM VW_XT_ZYBM00 WHERE BMMC00=RTRIM(@BMMC00)) BEGIN
		--取得部门编号
		SELECT TOP 1 @BMBH00=BMBH00 FROM VW_XT_ZYBM00 WHERE BMMC00=RTRIM(@BMMC00)
		IF @FLAG00='1' BEGIN
			DELETE FROM TJ_ZYRSJ0 WHERE BMBH00=@BMBH00 AND RQ0000=@RQ0000
		END ELSE BEGIN
                        IF EXISTS(SELECT RQ0000 FROM TJ_ZYRSJ0 WHERE RQ0000=@RQ0000 AND BMBH00=@BMBH00) BEGIN
			        FETCH ZYRSJ0_CURSOR INTO
                                      @RQ0000,@BMBH00,@MJZRCS,@YYRS00,@CYBRS0,@TQZYRS,
                                      @RYRS00,@TKZR00,@CYBSQ0,@CYSQXC,@CYSQJX,@CYSQQT,
                                      @CYBS00,@CYWS00,@CYGW00,@ZWTK00,@SYRS00,@PHRRS0,
                                      @WZRS00,@WZQJ00,@WZQJCG,@ZYRS00,@HZRS00,@WYRS00,
                                      @SWRS00,@SW2400,@QTHJ00,@ZCFMRS,@JHSYRS,@QTRS00,
                                      @ZLHJ00,@EXZL00,@YWA000,@LXZL00,@JJEXZL,@WZZL00,
                                      @SSRCS0,@WJSSLS,@WJGRLS,@SSQHFH,@SQBKD0,@RCZDFH,
                                      @RCBKD0,@BLZDS0,@LCBLFH,@MCFH00,@MCBKD0,@FSBLFH,
                                      @CYCF00,@SWCF00,@XSES00,@XSESWS,@MZRS00,@MZSWRS,
                                      @SRQZS0,@ZYZLS0,@ZXYZLS,@YYGR00,@BZCW00,@SYCW00,
                                      @SJKFCR,@SJZYCR,@CYZZYR,@ZYZZYR,@LRRQ00,@BMMC00
                                CONTINUE
                        END

		END
		--实际期初日期
    		SELECT @SJQSRQ=MAX(RQ0000) FROM TJ_ZYRSJ0 WHERE RQ0000<@RQ0000 AND BMBH00=@BMBH00
		SELECT @YYRS00 = SYRS00 , @BZCW00 = BZCW00 , @SYCW00 = SYCW00 FROM TJ_ZYRSJ0 WHERE RQ0000 = @SJQSRQ AND BMBH00=@BMBH00

		--计算指标重新计算
		SET @TQZYRS=ISNULL(@YYRS00,0)+ISNULL(@RYRS00,0)+ISNULL(@TKZR00,0)
		SET @SYRS00=ISNULL(@YYRS00,0)+ISNULL(@RYRS00,0)+ISNULL(@TKZR00,0)-ISNULL(@ZWTK00,0)-ISNULL(@CYBRS0,0)		
		SET @ZLHJ00=ISNULL(@EXZL00,0)+ISNULL(@YWA000,0)+ISNULL(@LXZL00,0)+ISNULL(@JJEXZL,0)+ISNULL(@WZZL00,0)
		SET @CYBSQ0=ISNULL(@CYSQXC,0)+ISNULL(@CYSQJX,0)+ISNULL(@CYSQQT,0)
		
		--如果编制床位<=0则取值XT_BMBM00->BZCW00、如果实有床位<=0则取值XT_BMBM00->BZCW00	
    		IF @BZCW00<=0 SELECT @BZCW00=BZCW00 FROM VW_XT_ZYBM00 WHERE BMBH00=@BMBH00
    		IF @SYCW00<=0 SET @SYCW00=@BZCW00
    		SET @SJKFCR=@SYCW00--*DATEDIFF(dd,@QSRQ00,@ZZRQ00)
    		SET @SJZYCR=@CYZZYR
		INSERT INTO TJ_ZYRSJ0(
			RQ0000,BMBH00,MJZRCS,YYRS00,CYBRS0,TQZYRS,
			RYRS00,TKZR00,CYBSQ0,CYSQXC,CYSQJX,CYSQQT,
			CYBS00,CYWS00,CYGW00,ZWTK00,SYRS00,PHRRS0,
			WZRS00,WZQJ00,WZQJCG,ZYRS00,HZRS00,WYRS00,
			SWRS00,SW2400,QTHJ00,ZCFMRS,JHSYRS,QTRS00,
			ZLHJ00,EXZL00,YWA000,LXZL00,JJEXZL,WZZL00,
			SSRCS0,WJSSLS,WJGRLS,SSQHFH,SQBKD0,RCZDFH,
			RCBKD0,BLZDS0,LCBLFH,MCFH00,MCBKD0,FSBLFH,
			CYCF00,SWCF00,XSES00,XSESWS,MZRS00,MZSWRS,
			SRQZS0,ZYZLS0,ZXYZLS,YYGR00,BZCW00,SYCW00,
			SJKFCR,SJZYCR,CYZZYR,ZYZZYR,LRRQ00,LRRY00
			)
		VALUES(
			@RQ0000,@BMBH00,@MJZRCS,@YYRS00,@CYBRS0,@TQZYRS,
			@RYRS00,@TKZR00,@CYBSQ0,@CYSQXC,@CYSQJX,@CYSQQT,
			@CYBS00,@CYWS00,@CYGW00,@ZWTK00,@SYRS00,@PHRRS0,
			@WZRS00,@WZQJ00,@WZQJCG,@ZYRS00,@HZRS00,@WYRS00,
			@SWRS00,@SW2400,@QTHJ00,@ZCFMRS,@JHSYRS,@QTRS00,
			@ZLHJ00,@EXZL00,@YWA000,@LXZL00,@JJEXZL,@WZZL00,
			@SSRCS0,@WJSSLS,@WJGRLS,@SSQHFH,@SQBKD0,@RCZDFH,
			@RCBKD0,@BLZDS0,@LCBLFH,@MCFH00,@MCBKD0,@FSBLFH,
			@CYCF00,@SWCF00,@XSES00,@XSESWS,@MZRS00,@MZSWRS,
			@SRQZS0,@ZYZLS0,@ZXYZLS,@YYGR00,
16      11:53:07  SQL Data In: MSSQL - Rows affected = 0
17      11:53:07  SQL Execute: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_MZ0000 @FLAG00 CHAR(1)
AS
DECLARE @RQ0000	DATETIME	--日期
DECLARE @BMBH00	NUMERIC(6)	--部门编号       
DECLARE @BMMC00 VARCHAR(20)	--部门名称
DECLARE @MJZYSS	INT		--普通门急诊医生数                  
DECLARE @MZZFZR	INT		--门诊正副主任医生数                
DECLARE @MJZRCS	INT		--门急诊人次数(门急诊人次数合计)    
DECLARE @PTMZRC	INT		--普通门诊人次数                    
DECLARE @ZFMZRC	INT		--主任、副主任门诊人次数            
DECLARE @JZRCS0	INT		--急诊人次数                        
DECLARE @JZWZQJ	INT		--其中：危重病人抢救人数            
DECLARE @JZWZCG	INT		--	危重病人抢救成功人数        
DECLARE @JZLYRS	INT		--急诊离院人数                      
DECLARE @JZRYRS	INT		--急诊入院人数                      
DECLARE @JZRGRS	INT		--急诊入观人数                      
DECLARE @JZZYRS	INT		--急诊转院人数                      
DECLARE @JZSWRS	INT		--急诊死亡人数                      
DECLARE @JZWSRS	INT		--急诊外伤人数                      
DECLARE @JZZDRS	INT		--急诊中毒人数                      
DECLARE @CZRCS0	INT		--出诊人次数                        
DECLARE @CCCS00	INT		--出车次数                          
DECLARE @JTBCS0	INT		--家庭病床数                        
DECLARE @JTFWRC	INT		--家庭卫生服务人次数                
DECLARE @WCDXJC	INT		--外出单项检查人次数
DECLARE @JKJCRC	INT		--健康检查人次数

DECLARE @CZRS00	INT		--初诊人数
DECLARE @FZRS00	INT		--复诊人数

DECLARE @LRRQ00	DATETIME	--录入日期
DECLARE @LRRY00	NUMERIC(5)	--录入人员                          
DECLARE @SJQSRQ DATETIME	--实际起始日期	
         
SELECT @LRRY00=YGBH00 FROM XT_YGBM00 WHERE ZWXM00='超级用户'
DECLARE MZRSJ0_CURSOR CURSOR FOR 
	SELECT 	RQ0000,BMBH00,BMMC00,MJZYSS,MZZFZR,MJZRCS,
		PTMZRC,ZFMZRC,JZRCS0,JZWZQJ,JZWZCG,JZLYRS,
		JZRYRS,JZRGRS,JZZYRS,JZSWRS,JZWSRS,JZZDRS,
		CZRCS0,CCCS00,JTBCS0,JTFWRC,WCDXJC,JKJCRC,
		LRRQ00,CZRS00,FZRS00
	FROM IMP_TJ_MZRSJ0
OPEN MZRSJ0_CURSOR
FETCH MZRSJ0_CURSOR INTO 
	@RQ0000,@BMBH00,@BMMC00,@MJZYSS,@MZZFZR,@MJZRCS,
	@PTMZRC,@ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS,
	@JZRYRS,@JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS,
	@CZRCS0,@CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC,
	@LRRQ00,@CZRS00,@FZRS00
WHILE (@@FETCH_STATUS=0) BEGIN
	IF EXISTS(SELECT BMBH00 FROM VW_XT_MZBM00 WHERE BMMC00=RTRIM(@BMMC00)) BEGIN
		--取得部门编号
		SELECT TOP 1 @BMBH00=BMBH00 FROM VW_XT_MZBM00 WHERE BMMC00=RTRIM(@BMMC00)
		IF @FLAG00='1' BEGIN
			DELETE FROM TJ_MZRSJ0 WHERE BMBH00=@BMBH00 AND RQ0000=@RQ0000
		END ELSE BEGIN
                        IF EXISTS(SELECT RQ0000 FROM TJ_MZRSJ0 WHERE RQ0000=@RQ0000 AND BMBH00=@BMBH00) BEGIN
        			FETCH MZRSJ0_CURSOR INTO
				        @RQ0000,@BMBH00,@BMMC00,@MJZYSS,@MZZFZR,@MJZRCS,
				        @PTMZRC,@ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS,
				        @JZRYRS,@JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS,
				        @CZRCS0,@CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC,
				        @LRRQ00,@CZRS00,@FZRS00
			        CONTINUE
                        END
		END
		--计算指标重新计算
		SET @MJZRCS=ISNULL(@PTMZRC,0)+ISNULL(@ZFMZRC,0)+ISNULL(@JZRCS0,0)
		INSERT INTO TJ_MZRSJ0(
			RQ0000,BMBH00,MJZYSS,MZZFZR,MJZRCS,PTMZRC,
			ZFMZRC,JZRCS0,JZWZQJ,JZWZCG,JZLYRS,JZRYRS,
			JZRGRS,JZZYRS,JZSWRS,JZWSRS,JZZDRS,CZRCS0,
			CCCS00,JTBCS0,JTFWRC,WCDXJC,JKJCRC,LRRQ00,
			LRRY00,CZRS00,FZRS00
			)
		VALUES(
			@RQ0000,@BMBH00,@MJZYSS,@MZZFZR,@MJZRCS,@PTMZRC,
			@ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS,@JZRYRS,
			@JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS,@CZRCS0,
			@CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC,@LRRQ00,
			@LRRY00,@CZRS00,@FZRS00
			)		
		
	END
	FETCH MZRSJ0_CURSOR INTO 
		@RQ0000,@BMBH00,@BMMC00,@MJZYSS,@MZZFZR,@MJZRCS,
		@PTMZRC,@ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS,
		@JZRYRS,@JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS,
		@CZRCS0,@CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC,
		@LRRQ00,@CZRS00,@FZRS00

END
CLOSE MZRSJ0_CURSOR
DEALLOCATE MZRSJ0_CURSOR

 
 
 
 
 

18      11:53:07  SQL Data In: MSSQL - Rows affected = 0
19      11:53:07  SQL Execute: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_GC0000 @FLAG00 CHAR(1)
AS
DECLARE @RQ0000	DATETIME	--日期                        
DECLARE @BMBH00	NUMERIC(6)	--部门编号       
DECLARE @BMMC00 VARCHAR(20)	--部门名称             
DECLARE @SYGCCS	INT		--实有观察床数            
DECLARE @YYRS00	INT		--原有人数                
DECLARE @RGRS00	INT		--入观人数                
DECLARE @CGRS00	INT		--出观人数                
DECLARE @LGRS00	INT		--留观人数                
DECLARE @CGRYRY	INT		--其中：入院人数          
DECLARE @CGRYZY	INT		--	转院人数          
DECLARE @CGRYFH	INT		--	返回人数          
DECLARE @CGRYSW	INT		--	死亡人数          
DECLARE @GCKFCR	INT 		--观察室开发床日数        
DECLARE @LGZYCR	INT		--留观占用床日数          
DECLARE @CGZYCR	INT		--出观占用床日数	  
DECLARE @LRRQ00	DATETIME	--录入日期                
DECLARE @LRRY00	NUMERIC(5)	--录入人员                

DECLARE @SJQSRQ DATETIME	--实际起始日期	
         
SELECT @LRRY00=YGBH00 FROM XT_YGBM00 WHERE ZWXM00='超级用户'
DECLARE GCRSJ0_CURSOR CURSOR FOR 
	SELECT 
		RQ0000,BMBH00,SYGCCS,YYRS00,RGRS00,CGRS00,
		LGRS00,CGRYRY,CGRYZY,CGRYFH,CGRYSW,GCKFCR,
		LGZYCR,CGZYCR,LRRQ00,BMMC00 
	FROM IMP_TJ_GCRSJ0
OPEN GCRSJ0_CURSOR                                        
FETCH GCRSJ0_CURSOR INTO                                  
	@RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00,
	@LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR,
	@LGZYCR,@CGZYCR,@LRRQ00,@BMMC00 
WHILE (@@FETCH_STATUS=0) BEGIN
	IF EXISTS(SELECT BMBH00 FROM VW_XT_GCBM00 WHERE BMMC00=RTRIM(@BMMC00)) BEGIN
		--取得部门编号
		SELECT TOP 1 @BMBH00=BMBH00 FROM VW_XT_GCBM00 WHERE BMMC00=RTRIM(@BMMC00)
		IF @FLAG00='1' BEGIN
			DELETE FROM TJ_GCRSJ0 WHERE BMBH00=@BMBH00 AND RQ0000=@RQ0000
		END ELSE BEGIN
                        IF EXISTS(SELECT RQ0000 FROM TJ_GCRSJ0 WHERE RQ0000=@RQ0000 AND BMBH00=@BMBH00) BEGIN
			        FETCH GCRSJ0_CURSOR INTO
				        @RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00,
				        @LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR,
				        @LGZYCR,@CGZYCR,@LRRQ00,@BMMC00
			        CONTINUE
                        END
		END
		--计算指标重新计算
		--实际期初日期
    		SELECT @SJQSRQ=MAX(RQ0000) FROM TJ_GCRSJ0 WHERE RQ0000<@RQ0000 AND BMBH00=@BMBH00
		SELECT @YYRS00 = LGRS00 FROM TJ_GCRSJ0 WHERE RQ0000 = @SJQSRQ AND BMBH00=@BMBH00
		SET @LGRS00=ISNULL(@YYRS00,0)+ISNULL(@RGRS00,0)+ISNULL(@CGRS00,0)		
		INSERT INTO TJ_GCRSJ0(
			RQ0000,BMBH00,SYGCCS,YYRS00,RGRS00,CGRS00,
			LGRS00,CGRYRY,CGRYZY,CGRYFH,CGRYSW,GCKFCR,
			LGZYCR,CGZYCR,LRRQ00,LRRY00
			)
		VALUES(
			@RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00,
			@LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR,
			@LGZYCR,@CGZYCR,@LRRQ00,@LRRY00
			)		
		
	END
	FETCH GCRSJ0_CURSOR INTO 
				@RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00,
				@LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR,
				@LGZYCR,@CGZYCR,@LRRQ00,@BMMC00
END
CLOSE GCRSJ0_CURSOR
DEALLOCATE GCRSJ0_CURSOR

 
 
 

20      11:53:07  SQL Data In: MSSQL - Rows affected = 0
21      11:53:07  SQL Execute: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_FZ0000 @FLAG00 CHAR(1)
AS
DECLARE @RQ0000	DATETIME	--日期    
DECLARE @BH0000	VARCHAR(20)	--分类编号
DECLARE @XMDM00	INT		--项目代码
DECLARE @SZ0000	NUMERIC(9,1)	--数值    
DECLARE @LRRQ00	DATETIME	--录入日期
DECLARE @LLRY00	VARCHAR(16)	--录入人员

DECLARE FZRSJ0_CURSOR CURSOR FOR 
	SELECT 	RQ0000,RTRIM(BH0000),XMDM00,SZ0000,LRRQ00,LLRY00
 	FROM IMP_TJ_FZRSJ0                                
OPEN FZRSJ0_CURSOR                                        
FETCH FZRSJ0_CURSOR INTO @RQ0000,@BH0000,@XMDM00,@SZ0000,@LRRQ00,@LLRY00
WHILE (@@FETCH_STATUS=0) BEGIN
	IF @FLAG00='1' BEGIN
		DELETE FROM TJ_FZRSJ0 WHERE BH0000=@BH0000 AND XMDM00=@XMDM00 AND RQ0000=@RQ0000
	END ELSE BEGIN
                IF EXISTS(SELECT RQ0000 FROM TJ_FZRSJ0 WHERE RQ0000=@RQ0000 AND BH0000=@BH0000) BEGIN
		        FETCH FZRSJ0_CURSOR INTO @RQ0000,@BH0000,@XMDM00,@SZ0000,@LRRQ00,@LLRY00
		        CONTINUE
                END
	END
	INSERT INTO TJ_FZRSJ0(
		RQ0000,BH0000,XMDM00,SZ0000,LRRQ00,LLRY00
		)
	VALUES(
		@RQ0000,@BH0000,@XMDM00,@SZ0000,CONVERT(VARCHAR(10),GETDATE(),102),'超级用户'
		)		
	FETCH FZRSJ0_CURSOR INTO @RQ0000,@BH0000,@XMDM00,@SZ0000,@LRRQ00,@LLRY00 
END
CLOSE FZRSJ0_CURSOR
DEALLOCATE FZRSJ0_CURSOR

 
 
 
 
 

22      11:53:07  SQL Data In: MSSQL - Rows affected = 0
23      11:53:07  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX')  
24      11:53:07  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.usertype = t.usertype order by colid ASC 
25      11:53:07  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZYXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
26      11:53:07  SQL Execute: MSSQL -  BEGIN TRAN 
27      11:53:07  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_BRZYXX HOLDLOCK WHERE 0=1 
28      11:53:07  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX')  
29      11:53:07  SQL Execute: MSSQL -  COMMIT TRAN 
30      11:53:07  SQL Execute: MSSQL -  DROP TABLE DBO.IMP_BA_BRZYXX
31      11:53:07  SQL Execute: MSSQL -  CREATE TABLE DBO.IMP_BA_BRZYXX ( LSH000 varchar (10) null,BAH000 varchar (20) null,ZYCS00 varchar (30) null,ZYH000 varchar (20) null,BRXM00 varchar (20) null,BRXB00 varchar (16) null,BRCSRQ varchar (16) null,BRNL00 varchar (8) null,HYZK00 varchar (8) null,ZY0000 varchar (50) null,BRLY00 varchar (20) null,CSSF00 varchar (30) null,CSXS00 varchar (30) null,MZ0000 varchar (30) null,GJ0000 varchar (30) null,SFZH00 varchar (30) null,GZDW00 varchar (100) null,GZDH00 varchar (50) null,GZYB00 varchar (10) null,JTDZ00 varchar (100) null,JTDH00 varchar (30) null,JTYB00 varchar (16) null,LXRXM0 varchar (26) null,LXRDZ0 varchar (100) null,LXRDH0 varchar (30) null,LXRGX0 varchar (20) null,ZDFS00 varchar (15) null,RYQK00 varchar (20) null,RYRQ00 varchar (12) null,RYSJ00 varchar (12) null,RYKB00 varchar (8) null,RYKBMC varchar (30) null,RYBF00 varchar (20) null,ZKKB00 varchar (50) null,ZKKBMC varchar (50) null,CYRQ00 varchar (12) null,CYSJ00 varchar (12) null,CYKB00 varchar (8) null,CYKBMC varchar (30) null,CYBF00 varchar (20) null,ZYTS00 varchar (8) null,QZRQ00 varchar (12) null,BLZD00 varchar (200) null,GMYW00 varchar (100) null,HBSAG0 varchar (10) null,HCVAB0 varchar (10) null,HIVAB0 varchar (10) null,MZCYFH varchar (10) null,RYCYFH varchar (10) null,SQSHFH varchar (10) null,LCBLFH varchar (6) null,FSBLFH varchar (10) null,QJCS00 varchar (10) null,CGCS00 varchar (10) null,BAZL00 varchar (10) null,SFSJ00 varchar (10) null,DYBL00 varchar (10) null,SFSZ00 varchar (10) null,SZQX00 varchar (10) null,SJBL00 varchar (10) null,XX0000 varchar (6) null,RH0000 varchar (12) null,SXFY00 varchar (12) null,HXB000 varchar (12) null,XXB000 varchar (12) null,XJ0000 varchar (12) null,QX0000 varchar (12) null,SXQT00 varchar (12) null,ZKRQ00 varchar (12) null,BAZT00 varchar (12) null,SRRK00 varchar (4) null,LRRY00 varchar (4) null,LRRQ00 varchar (8) null,JFFS00 varchar (40) null,ZJE000 varchar (40) null,ZYLSH0 varchar (20) null,ZYID00 varchar (20) null,CARDNO varchar (20) null,BZ0000 varchar (100) null,JKDAH0 varchar (20) null,BRNLY0 varchar (30) null,BRNLR0 varchar (8) null,CSDS00 varchar (50) null,JGSF00 varchar (50) null,JGXS00 varchar (50) null,YECSTZ varchar (10) null,YERYTZ varchar (50) null,XZZ000 varchar (50) null,XZZDH0 varchar (50) null,XZZYB0 varchar (50) null,RYTJ00 varchar (30) null,BLZDBM varchar (30) null,BLH000 varchar (30) null,SFYWGM varchar (30) null,LYFS00 varchar (100) null,ZYYLJG varchar (30) null,ZZYJH0 varchar (50) null,ZZYMD0 varchar (30) null,HMRYQD varchar (30) null,HMRYQH varchar (30) null,HMRYQM varchar (30) null,HMRYHD varchar (30) null,HMRYHH varchar (30) null,HMRYHM varchar (30) null,SSZDYY varchar (200) null,SSZDBM varchar (50) null,LRRYMC varchar (30) null,SSLCLJ varchar (20) null,LJWCQK varchar (8) null,BQQZQK varchar (10) null ) 
32      11:53:07  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX')  
33      11:53:07  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.usertype = t.usertype order by colid ASC 
34      11:53:07  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZYXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
35      11:53:07  SQL Execute: MSSQL -  BEGIN TRAN 
36      11:53:07  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_BRZYXX HOLDLOCK WHERE 0=1 
37      11:53:07  SQL Execute: MSSQL -  COMMIT TRAN 
38      11:53:07  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX')  
39      11:53:07  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.usertype = t.usertype order by colid ASC 
40      11:53:07  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZYXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
41      11:53:07  SQL Execute: MSSQL - select c.name, c.status, o.name from syscolumns c, sysobjects o where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.cdefault *= o.id order by colid ASC 
42      11:53:07  SQL Execute: MSSQL - SELECT LSH000 ,BAH000 ,ZYCS00 ,ZYH000 ,BRXM00 ,BRXB00 ,BRCSRQ ,BRNL00 ,HYZK00 ,ZY0000 ,BRLY00 ,CSSF00 ,CSXS00 ,MZ0000 ,GJ0000 ,SFZH00 ,GZDW00 ,GZDH00 ,GZYB00 ,JTDZ00 ,JTDH00 ,JTYB00 ,LXRXM0 ,LXRDZ0 ,LXRDH0 ,LXRGX0 ,ZDFS00 ,RYQK00 ,RYRQ00 ,RYSJ00 ,RYKB00 ,RYKBMC ,RYBF00 ,ZKKB00 ,ZKKBMC ,CYRQ00 ,CYSJ00 ,CYKB00 ,CYKBMC ,CYBF00 ,ZYTS00 ,QZRQ00 ,BLZD00 ,GMYW00 ,HBSAG0 ,HCVAB0 ,HIVAB0 ,MZCYFH ,RYCYFH ,SQSHFH ,LCBLFH ,FSBLFH ,QJCS00 ,CGCS00 ,BAZL00 ,SFSJ00 ,DYBL00 ,SFSZ00 ,SZQX00 ,SJBL00 ,XX0000 ,RH0000 ,SXFY00 ,HXB000 ,XXB000 ,XJ0000 ,QX0000 ,SXQT00 ,ZKRQ00 ,BAZT00 ,SRRK00 ,LRRY00 ,LRRQ00 ,JFFS00 ,ZJE000 ,ZYLSH0 ,ZYID00 ,CARDNO ,BZ0000 ,JKDAH0 ,BRNLY0 ,BRNLR0 ,CSDS00 ,JGSF00 ,JGXS00 ,YECSTZ ,YERYTZ ,XZZ000 ,XZZDH0 ,XZZYB0 ,RYTJ00 ,BLZDBM ,BLH000 ,SFYWGM ,LYFS00 ,ZYYLJG ,ZZYJH0 ,ZZYMD0 ,HMRYQD ,HMRYQH ,HMRYQM ,HMRYHD ,HMRYHH ,HMRYHM ,SSZDYY ,SSZDBM ,LRRYMC ,SSLCLJ ,LJWCQK ,BQQZQK  FROM IMP_BA_BRZYXX
43      11:53:07  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZDXX')  
44      11:53:07  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZDXX') and c.usertype = t.usertype order by colid ASC 
45      11:53:07  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZDXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZDXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
46      11:53:07  SQL Execute: MSSQL -  BEGIN TRAN 
47      11:53:07  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_BRZDXX HOLDLOCK WHERE 0=1 
48      11:53:07  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZDXX')  
49      11:53:07  SQL Execute: MSSQL -  COMMIT TRAN 
50      11:53:07  SQL Execute: MSSQL -  DROP TABLE DBO.IMP_BA_BRZDXX
51      11:53:07  SQL Execute: MSSQL -  CREATE TABLE DBO.IMP_BA_BRZDXX ( LSH000 varchar (10) null,ZDXH00 varchar (10) null,ZDLB00 varchar (10) null,JBBM00 varchar (20) null,XHBM00 varchar (20) null,JBMC00 varchar (200) null,FZBM00 varchar (30) null,FZMC00 varchar (50) null,ZDRQ00 varchar (30) null,ZLXG00 varchar (30) null,SFYZ00 varchar (10) null,M16800 varchar (20) null,RYBQ00 varchar (20) null ) 
52      11:53:07  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZDXX')  
53      11:53:07  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZDXX') and c.usertype = t.usertype order by colid ASC 
54      11:53:07  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZDXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZDXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
55      11:53:07  SQL Execute: MSSQL -  BEGIN TRAN 
56      11:53:07  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_BRZDXX HOLDLOCK WHERE 0=1 
57      11:53:07  SQL Execute: MSSQL -  COMMIT TRAN 
58      11:53:07  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZDXX')  
59      11:53:07  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZDXX') and c.usertype = t.usertype order by colid ASC 
60      11:53:07  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZDXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZDXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
61      11:53:07  SQL Execute: MSSQL - select c.name, c.status, o.name from syscolumns c, sysobjects o where c.id = object_id ('DBO.IMP_BA_BRZDXX') and c.cdefault *= o.id order by colid ASC 
62      11:53:07  SQL Execute: MSSQL - SELECT LSH000 ,ZDXH00 ,ZDLB00 ,JBBM00 ,XHBM00 ,JBMC00 ,FZBM00 ,FZMC00 ,ZDRQ00 ,ZLXG00 ,SFYZ00 ,M16800 ,RYBQ00  FROM IMP_BA_BRZDXX
63      11:53:07  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRSSXX')  
64      11:53:07  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRSSXX') and c.usertype = t.usertype order by colid ASC 
65      11:53:07  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRSSXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRSSXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
66      11:53:07  SQL Execute: MSSQL -  BEGIN TRAN 
67      11:53:07  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_BRSSXX HOLDLOCK WHERE 0=1 
68      11:53:07  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRSSXX')  
69      11:53:07  SQL Execute: MSSQL -  COMMIT TRAN 
70      11:53:07  SQL Execute: MSSQL -  DROP TABLE DBO.IMP_BA_BRSSXX
71      11:53:07  SQL Execute: MSSQL -  CREATE TABLE DBO.IMP_BA_BRSSXX ( LSH000 varchar (10) null,SSXH00 varchar (10) null,SSLB00 varchar (10) null,SSM000 varchar (20) null,SSMC00 varchar (200) null,SSRQ00 varchar (40) null,SSSJ00 varchar (40) null,SSZL00 varchar (40) null,SSYS00 varchar (40) null,SSYSMC varchar (40) null,IYS000 varchar (60) null,IYSMC0 varchar (60) null,IIYS00 varchar (60) null,IIYSMC varchar (60) null,MZFS00 varchar (60) null,QKYHDJ varchar (60) null,MZYS00 varchar (60) null,MZYSMC varchar (60) null ) 
72      11:53:07  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRSSXX')  
73      11:53:07  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRSSXX') and c.usertype = t.usertype order by colid ASC 
74      11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRSSXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRSSXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
75      11:53:08  SQL Execute: MSSQL -  BEGIN TRAN 
76      11:53:08  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_BRSSXX HOLDLOCK WHERE 0=1 
77      11:53:08  SQL Execute: MSSQL -  COMMIT TRAN 
78      11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRSSXX')  
79      11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRSSXX') and c.usertype = t.usertype order by colid ASC 
80      11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRSSXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRSSXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
81      11:53:08  SQL Execute: MSSQL - select c.name, c.status, o.name from syscolumns c, sysobjects o where c.id = object_id ('DBO.IMP_BA_BRSSXX') and c.cdefault *= o.id order by colid ASC 
82      11:53:08  SQL Execute: MSSQL - SELECT LSH000 ,SSXH00 ,SSLB00 ,SSM000 ,SSMC00 ,SSRQ00 ,SSSJ00 ,SSZL00 ,SSYS00 ,SSYSMC ,IYS000 ,IYSMC0 ,IIYS00 ,IIYSMC ,MZFS00 ,QKYHDJ ,MZYS00 ,MZYSMC  FROM IMP_BA_BRSSXX
83      11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRJSXX')  
84      11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRJSXX') and c.usertype = t.usertype order by colid ASC 
85      11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRJSXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRJSXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
86      11:53:08  SQL Execute: MSSQL -  BEGIN TRAN 
87      11:53:08  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_BRJSXX HOLDLOCK WHERE 0=1 
88      11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRJSXX')  
89      11:53:08  SQL Execute: MSSQL -  COMMIT TRAN 
90      11:53:08  SQL Execute: MSSQL -  DROP TABLE DBO.IMP_BA_BRJSXX
91      11:53:08  SQL Execute: MSSQL -  CREATE TABLE DBO.IMP_BA_BRJSXX ( LSH000 float null,JSXH00 smallint null,YC0000 smallint null,CC0000 smallint null,TS0000 varchar (10) null,FMFS00 varchar (10) null,HYPL00 varchar (8) null,HYZS00 varchar (8) null,SYTS00 smallint null,YEQK00 varchar (16) null,APGAR0 smallint null,JSYS00 varchar (30) null,JSYSMC varchar (40) null,YECSRQ datetime null,YETZ00 smallint null,YEXB00 varchar (16) null ) 
92      11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRJSXX')  
93      11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRJSXX') and c.usertype = t.usertype order by colid ASC 
94      11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRJSXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRJSXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
95      11:53:08  SQL Execute: MSSQL -  BEGIN TRAN 
96      11:53:08  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_BRJSXX HOLDLOCK WHERE 0=1 
97      11:53:08  SQL Execute: MSSQL -  COMMIT TRAN 
98      11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRJSXX')  
99      11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRJSXX') and c.usertype = t.usertype order by colid ASC 
100     11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRJSXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRJSXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
101     11:53:08  SQL Execute: MSSQL - select c.name, c.status, o.name from syscolumns c, sysobjects o where c.id = object_id ('DBO.IMP_BA_BRJSXX') and c.cdefault *= o.id order by colid ASC 
102     11:53:08  SQL Execute: MSSQL - SELECT LSH000 ,JSXH00 ,YC0000 ,CC0000 ,TS0000 ,FMFS00 ,HYPL00 ,HYZS00 ,SYTS00 ,YEQK00 ,APGAR0 ,JSYS00 ,JSYSMC ,YECSRQ ,YETZ00 ,YEXB00  FROM IMP_BA_BRJSXX
103     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRFYXX')  
104     11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRFYXX') and c.usertype = t.usertype order by colid ASC 
105     11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRFYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRFYXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
106     11:53:08  SQL Execute: MSSQL -  BEGIN TRAN 
107     11:53:08  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_BRFYXX HOLDLOCK WHERE 0=1 
108     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRFYXX')  
109     11:53:08  SQL Execute: MSSQL -  COMMIT TRAN 
110     11:53:08  SQL Execute: MSSQL -  DROP TABLE DBO.IMP_BA_BRFYXX
111     11:53:08  SQL Execute: MSSQL -  CREATE TABLE DBO.IMP_BA_BRFYXX ( LSH000 varchar (10) null,FYDM00 varchar (6) null,FYMC00 varchar (40) null,JFFS00 varchar (20) null,JE0000 varchar (10) null ) 
112     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRFYXX')  
113     11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRFYXX') and c.usertype = t.usertype order by colid ASC 
114     11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRFYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRFYXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
115     11:53:08  SQL Execute: MSSQL -  BEGIN TRAN 
116     11:53:08  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_BRFYXX HOLDLOCK WHERE 0=1 
117     11:53:08  SQL Execute: MSSQL -  COMMIT TRAN 
118     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRFYXX')  
119     11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRFYXX') and c.usertype = t.usertype order by colid ASC 
120     11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRFYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRFYXX') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
121     11:53:08  SQL Execute: MSSQL - select c.name, c.status, o.name from syscolumns c, sysobjects o where c.id = object_id ('DBO.IMP_BA_BRFYXX') and c.cdefault *= o.id order by colid ASC 
122     11:53:08  SQL Execute: MSSQL - SELECT LSH000 ,FYDM00 ,FYMC00 ,JFFS00 ,JE0000  FROM IMP_BA_BRFYXX
123     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_YSXX00')  
124     11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_YSXX00') and c.usertype = t.usertype order by colid ASC 
125     11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_YSXX00', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_YSXX00') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
126     11:53:08  SQL Execute: MSSQL -  BEGIN TRAN 
127     11:53:08  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_YSXX00 HOLDLOCK WHERE 0=1 
128     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_YSXX00')  
129     11:53:08  SQL Execute: MSSQL -  COMMIT TRAN 
130     11:53:08  SQL Execute: MSSQL -  DROP TABLE DBO.IMP_BA_YSXX00
131     11:53:08  SQL Execute: MSSQL -  CREATE TABLE DBO.IMP_BA_YSXX00 ( LSH000 varchar (10) null,KZR000 varchar (30) null,KZRMC0 varchar (40) null,FZR000 varchar (30) null,FZRMC0 varchar (40) null,ZZYS00 varchar (30) null,ZZYSMC varchar (40) null,ZYYS00 varchar (30) null,ZYYSMC varchar (40) null,JXYS00 varchar (30) null,JXYSMC varchar (40) null,YJSYS0 varchar (30) null,YJSMC0 varchar (40) null,SXYS00 varchar (30) null,SXYSMC varchar (40) null,ZKYS00 varchar (30) null,ZKYSMC varchar (40) null,ZKHS00 varchar (30) null,ZKHSMC varchar (40) null,JSYS00 varchar (30) null,JSYSMC varchar (40) null,ZRHS00 varchar (30) null,ZRHSMC varchar (40) null ) 
132     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_YSXX00')  
133     11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_YSXX00') and c.usertype = t.usertype order by colid ASC 
134     11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_YSXX00', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_YSXX00') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
135     11:53:08  SQL Execute: MSSQL -  BEGIN TRAN 
136     11:53:08  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_BA_YSXX00 HOLDLOCK WHERE 0=1 
137     11:53:08  SQL Execute: MSSQL -  COMMIT TRAN 
138     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_YSXX00')  
139     11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_YSXX00') and c.usertype = t.usertype order by colid ASC 
140     11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_YSXX00', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_YSXX00') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
141     11:53:08  SQL Execute: MSSQL - select c.name, c.status, o.name from syscolumns c, sysobjects o where c.id = object_id ('DBO.IMP_BA_YSXX00') and c.cdefault *= o.id order by colid ASC 
142     11:53:08  SQL Execute: MSSQL - SELECT LSH000 ,KZR000 ,KZRMC0 ,FZR000 ,FZRMC0 ,ZZYS00 ,ZZYSMC ,ZYYS00 ,ZYYSMC ,JXYS00 ,JXYSMC ,YJSYS0 ,YJSMC0 ,SXYS00 ,SXYSMC ,ZKYS00 ,ZKYSMC ,ZKHS00 ,ZKHSMC ,JSYS00 ,JSYSMC ,ZRHS00 ,ZRHSMC  FROM IMP_BA_YSXX00
143     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_TJ_MZRSJ0')  
144     11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_TJ_MZRSJ0') and c.usertype = t.usertype order by colid ASC 
145     11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_TJ_MZRSJ0', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_TJ_MZRSJ0') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
146     11:53:08  SQL Execute: MSSQL -  BEGIN TRAN 
147     11:53:08  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_TJ_MZRSJ0 HOLDLOCK WHERE 0=1 
148     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_TJ_MZRSJ0')  
149     11:53:08  SQL Execute: MSSQL -  COMMIT TRAN 
150     11:53:08  SQL Execute: MSSQL -  DROP TABLE DBO.IMP_TJ_MZRSJ0
151     11:53:08  SQL Execute: MSSQL -  CREATE TABLE DBO.IMP_TJ_MZRSJ0 ( RQ0000 varchar (8) null,BMBH00 varchar (6) null,MJZYSS varchar (8) null,MZZFZR varchar (8) null,MJZRCS varchar (8) null,PTMZRC varchar (8) null,ZFMZRC varchar (8) null,JZRCS0 varchar (8) null,JZWZQJ varchar (8) null,JZLYRS varchar (8) null,JZRGRS varchar (8) null,JZZYRS varchar (8) null,JZSWRS varchar (8) null,JZWSRS varchar (8) null,JZZDRS varchar (8) null,CZRCS0 varchar (8) null,CCCS00 varchar (8) null,JTBCS0 varchar (8) null,JTFWRC varchar (8) null,WCDXJC varchar (8) null,JKJCRC varchar (8) null,LRRQ00 varchar (8) null,LRRY00 varchar (5) null,BMMC00 varchar (20) null,JZWZCG varchar (8) null,JZRYRS varchar (8) null,CZRS00 varchar (8) null,FZRS00 varchar (8) null ) 
152     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_TJ_MZRSJ0')  
153     11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_TJ_MZRSJ0') and c.usertype = t.usertype order by colid ASC 
154     11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_TJ_MZRSJ0', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_TJ_MZRSJ0') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
155     11:53:08  SQL Execute: MSSQL -  BEGIN TRAN 
156     11:53:08  SQL Execute: MSSQL -  SELECT * FROM DBO.IMP_TJ_MZRSJ0 HOLDLOCK WHERE 0=1 
157     11:53:08  SQL Execute: MSSQL -  COMMIT TRAN 
158     11:53:08  SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_TJ_MZRSJ0')  
159     11:53:08  SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_TJ_MZRSJ0') and c.usertype = t.usertype order by colid ASC 
160     11:53:08  SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_TJ_MZRSJ0', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_TJ_MZRSJ0') and indid between 1 and 254 and x.id = c.id  and c.colid <= x.keycnt order by x.indid, c.colid ASC 
161     11:53:08  SQL Execute: MSSQL - select c.name, c.status, o.name from syscolumns c, sysobjects o where c.id = object_id ('DBO.IMP_TJ_MZRSJ0') and c.cdefault *= o.id order by colid ASC 
162     11:53:08  SQL Execute: MSSQL - SELECT RQ0000 ,BMBH00 ,MJZYSS ,MZZFZR ,MJZRCS ,PTMZRC ,ZFMZRC ,JZRCS0 ,JZWZQJ ,JZLYRS ,JZRGRS ,JZZYRS ,JZSWRS ,JZWSRS ,JZZDRS ,CZRCS0 ,CCCS00 ,JTBCS0 ,JTFWRC ,WCDXJC ,JKJCRC ,LRRQ00 ,LRRY00 ,BMMC00 ,JZWZCG ,JZRYRS ,CZRS00 ,FZRS00  FROM IMP_TJ_MZRSJ0
163     11:53:08  SQL Execute: MSSQL - Exec SP_IMP000_BA0000 "1"

164     11:53:08  SQL Data In: MSSQL - Rows affected = 0
165     11:53:08  SQL Execute: MSSQL - Exec SP_IMP000_MZ0000 "1"

166     11:53:08  SQL Data In: MSSQL - Rows affected = 0
167     11:53:08  SQL Execute: MSSQL - Exec SP_IMP000_ZY0000 "1"

168     11:53:08  SQL Data In: MSSQL - Rows affected = 0
169     11:53:08  SQL Execute: MSSQL - Exec SP_IMP000_FZ0000 "1"

170     11:53:08  SQL Data In: MSSQL - Rows affected = 0
171     11:53:08  SQL Execute: MSSQL - Exec SP_IMP000_GC0000 "1"

172     11:53:08  SQL Data In: MSSQL - Rows affected = 0
173     11:53:08  SQL Execute: MSSQL -  insert into BA_DRRQ00 (czbz00,drrq00,czrq00,zwxm00) values('1','2018.11.23',GETDATE(),'')