金蝶s-HR-修改人事档案重复语句.txt

备份select*intoT_HR_PERSONBURELATION1203fromT_HR_PERSONBURELATIONSELECT*intoT_HR_EMPHRORELATIONHIS1203fromT_HR_EMPHRORELATIONHIS查看是否人事档案重复SELECTfidFROMt_bd_personwherefnumber='员工编码'----第一句复制fidSELECT*FROMT_HR_PERSONBURELATIONwhereFPERSONID='第一句的fid'andFBIZMANAGETYPEID='SGuJm3nXW0GshQfKRXenomWJ1dE='---第二句复制fidSELECT*FROMT_HR_EMPHRORELATIONHISwhereFPERSONID='第一句的fid'删除语句，务必确认是人事档案重复再执行删除语句！DELETEFROMT_HR_PERSONBURELATIONWHEREFPERSONID='第一句的fid'andFBIZMANAGETYPEID='SGuJm3nXW0GshQfKRXenomWJ1dE='andFID='第二句的fid'DELETEFROMT_HR_EMPHRORELATIONHISWHEREFPERSONID='第一句的fid'andFBURELATIONID='第二句的fid'