--uSYS00011F“―Žž“―‹ΖŽζˆψ‰‰KiSJ6jv‚Μ‰οŒvI—Ή“ϊ‚πu‰οŒvŠJŽnŒŽ‚ΜŒŽ––(’ʏν‚Ν4/30)v‚ɕύX UPDATE TC2‰‰KM SET ‰οŒvI—Ή“ϊ = DATEADD(month, 1, ‰οŒvŠJŽn“ϊ) WHERE ‰‰KCD = 'SYS00011' UPDATE TC2‰‰KM SET ‰οŒvI—Ή“ϊ = DATEADD(day, -1, ‰οŒvI—Ή“ϊ) WHERE ‰‰KCD = 'SYS00011' --ƒŠƒl[ƒ€‚³‚κ‚½‹Œƒe[ƒuƒ‹‚©‚ηƒCƒ“ƒ|[ƒg INSERT INTO TTAŽΠˆυ‘δ’ M ( ƒVƒXƒeƒ€CD , ‰‰KCD , ‰οŽΠCD , ŽΠˆυ”ԍ† , ƒ}ƒXƒ^CD , ŽΠˆυ”ԍ†ƒ‰ƒxƒ‹ , Ž–Ό , —X•Φ”ԍ† , ZŠ , “d˜b”ԍ† , ƒP[ƒ^ƒC , Ά”NŒŽ“ϊ , •}—{‰Ζ‘°l” , “όŽΠ”NŒŽ“ϊ , —£E”NŒŽ“ϊ , –πE , Šξ–{‹‹ , E–±Žθ“– , ‰Ζ‘°Žθ“– , Z‘ξŽθ“– , Έ‹ΞŽθ“– , ŠF‹ΞŽθ“– , ’Κ‹ΞŽθ“– , Œ’N•ΫŒ― , ŒϊΆ”N‹ΰ , ”N‹ΰŠξ‹ΰ , ŒΩ—p•ΫŒ― , ‰ξŒμ•ΫŒ― , ‘γ•\Žζ’χ–πƒtƒ‰ƒO , ŠwΆ”ԍ† , —\”υ‚  , —\”υ‚’ , —\”υ‚€ , —\”υ1 , —\”υ2 , —\”υ3 ) SELECT ƒVƒXƒeƒ€CD , ‰‰KCD , ‰οŽΠCD , ŽΠˆυ”ԍ† , null , ŽΠˆυ”ԍ†ƒ‰ƒxƒ‹ , Ž–Ό , —X•Φ”ԍ† , ZŠ , “d˜b”ԍ† , ƒP[ƒ^ƒC , Ά”NŒŽ“ϊ , •}—{‰Ζ‘°l” , “όŽΠ”NŒŽ“ϊ , —£E”NŒŽ“ϊ , –πE , Šξ–{‹‹ , E–±Žθ“– , ‰Ζ‘°Žθ“– , Z‘ξŽθ“– , Έ‹ΞŽθ“– , ŠF‹ΞŽθ“– , ’Κ‹ΞŽθ“– , Œ’N•ΫŒ― , ŒϊΆ”N‹ΰ , ”N‹ΰŠξ‹ΰ , ŒΩ—p•ΫŒ― , ‰ξŒμ•ΫŒ― , ‘γ•\Žζ’χ–πƒtƒ‰ƒO , ŠwΆ”ԍ† , —\”υ‚  , —\”υ‚’ , —\”υ‚€ , —\”υ1 , —\”υ2 , —\”υ3 FROM OLD_TTAŽΠˆυ‘δ’ M