老病人信息插入TECH库-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_42335056/article/details/95309657

               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