GaramX

문서의 이전 판입니다!

---

UPDATE REP_INSUR_ACC

 SET end_ymd=(select dbo.XF_NVL_D(dbo.XF_DATEADD(min(calc_ymd),-1) , X.end_ymd )
				  FROM REP_INSUR_ACC as A
				 WHERE A.calc_ymd > X.calc_ymd
				   AND A.company_cd = X.company_cd
				   AND A.ctz_no = X.ctz_no
				   AND A.emp_id = X.emp_id)
FROM REP_INSUR_ACC as X

WHERE 1=1

 AND X.company_cd  = 'E'
 AND X.ctz_no  = 'qzDppshPl9Oti+cRoA2hRQ=='
 AND X.emp_id  = '60487' 

;