老病人信息插入TECH库

                BEGIN TRAN 
                    insert into HIS_ZYPATINFO
                    (patientid,cureno,blh,cardno,cardtype,patname,sex,sexname,birth,yexh,ksdm,ksmc,bqdm,bqmc,ysdm,ysmc,cwmc,
                    brzt,ryrq,cyrq,chargetype,address,phone,czsj)
                    SELECT patid,syxh,blh,cardno,cardtype,hzxm,case when a.sex = '男' then 1 else 2 end sex,a.sex sexname,
                    substring(a.birth,1,4)+'-'+SUBSTRING(a.birth,5,2)+'-'+SUBSTRING(a.birth,7,2)+ ' 00:00:00.000',0,ksdm,c.name,bqdm,b.name,
                    ysdm,d.name,cwdm,brzt,substring(a.ryrq,1,4)+'-'+SUBSTRING(a.ryrq,5,2)+'-'+SUBSTRING(a.ryrq,7,2)+' '+ SUBSTRING(a.ryrq,9,12),cyrq,ybdm,lxrdz,lxrdh,'2019-07-10 09:00:30' FROM THIS.THIS4.dbo.ZY_BRSYK a
                    LEFT JOIN THIS.THIS4.dbo.ZY_BQDMK b ON a.bqdm = b.id 
                    left join THIS.THIS4.dbo.YY_KSBMK c on a.ksdm = c.id
                    left join THIS.THIS4.dbo.YY_ZGBMK d on a.ysdm = d.id
                     WHERE brzt = '1' and patid not in (
                    select patientid from HIS_ZYPATINFO
                    ) and bqdm  <> '999'
                ROLLBACK TRAN