osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "INSERT INTO TC1ƒVƒXƒeƒ€M (ƒVƒXƒeƒ€CD, ƒ†[ƒU[–¼, ƒfƒtƒHƒ‹ƒgƒtƒ‰ƒO) SELECT 'SFC', 'ƒf[ƒ^ƒCƒ“ƒ|[ƒg—p', '0' WHERE (NOT EXISTS (SELECT * FROM TC1ƒVƒXƒeƒ€M WHERE ƒVƒXƒeƒ€CD = 'SFC'))" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "INSERT INTO TC1ƒVƒXƒeƒ€M (ƒVƒXƒeƒ€CD, ƒ†[ƒU[–¼, ƒfƒtƒHƒ‹ƒgƒtƒ‰ƒO) VALUES ('INPORT14', 'ƒf[ƒ^ƒCƒ“ƒ|[ƒg—p', '0')" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "INSERT INTO TC2‰‰KM (ƒVƒXƒeƒ€CD, ‰‰KCD, ‰‰K–¼Ì) SELECT 'SFC', 'SYSORIGN', 'ƒf[ƒ^ƒCƒ“ƒ|[ƒg—p' WHERE (NOT EXISTS (SELECT * FROM TC2‰‰KM WHERE ƒVƒXƒeƒ€CD = 'SFC' AND ‰‰KCD = 'SYSORIGN'))" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "INSERT INTO TC2‰‰KM (ƒVƒXƒeƒ€CD, ‰‰KCD, ‰‰K–¼Ì) VALUES ('INPORT14', 'SYSORIGN', 'ƒo[ƒWƒ‡ƒ“ƒAƒbƒv—p')" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TC9‹æ•ªM" bcp sj4webdb.dbo.TC9‹æ•ªM in TC9‹æ•ªM.csv /e TC9‹æ•ªM_in_err.txt /c /t ::: /r ;;;\n /S %1 /U sj4user /P sj4 osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "UPDATE TC9‹æ•ªM SET ƒVƒXƒeƒ€CD = 'INPORT14'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "INSERT INTO TC9‹æ•ªM(ƒVƒXƒeƒ€CD,ƒf[ƒ^Ž¯•Ê,‹æ•ªCD,‹æ•ª–¼Ì,‡˜,—\”õ‚ ,—\”õ‚¢,—\”õ‚¤,—\”õ1,—\”õ2,—\”õ3) SELECT TC1ƒVƒXƒeƒ€M.ƒVƒXƒeƒ€CD,TC9‹æ•ªM.ƒf[ƒ^Ž¯•Ê,TC9‹æ•ªM.‹æ•ªCD,TC9‹æ•ªM.‹æ•ª–¼Ì,TC9‹æ•ªM.‡˜,TC9‹æ•ªM.—\”õ‚ ,TC9‹æ•ªM.—\”õ‚¢,TC9‹æ•ªM.—\”õ‚¤,TC9‹æ•ªM.—\”õ1,TC9‹æ•ªM.—\”õ2,TC9‹æ•ªM.—\”õ3 FROM TC9‹æ•ªM CROSS JOIN TC1ƒVƒXƒeƒ€M WHERE (TC1ƒVƒXƒeƒ€M.ƒfƒtƒHƒ‹ƒgƒtƒ‰ƒO = 1) AND (TC9‹æ•ªM.ƒVƒXƒeƒ€CD = 'INPORT14')" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TC9‹æ•ªM WHERE ƒVƒXƒeƒ€CD = 'INPORT14'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TC9–¼ŽhƒfƒUƒCƒ“M" bcp sj4webdb.dbo.TC9–¼ŽhƒfƒUƒCƒ“M in TC9–¼ŽhƒfƒUƒCƒ“M.csv /e TC9–¼ŽhƒfƒUƒCƒ“M_in_err.txt /c /t ::: /r ;;;\n /S %1 /U sj4user /P sj4 osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "UPDATE TC9–¼ŽhƒfƒUƒCƒ“M SET ƒVƒXƒeƒ€CD = 'INPORT14'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "INSERT INTO TC9–¼ŽhƒfƒUƒCƒ“M(ƒVƒXƒeƒ€CD,–¼ŽhƒfƒUƒCƒ“CD,c‰¡‹æ•ª,ƒfƒUƒCƒ“,—\”õ‚ ,—\”õ‚¢,—\”õ‚¤,—\”õ1,—\”õ2,—\”õ3) SELECT TC1ƒVƒXƒeƒ€M.ƒVƒXƒeƒ€CD,TC9–¼ŽhƒfƒUƒCƒ“M.–¼ŽhƒfƒUƒCƒ“CD,TC9–¼ŽhƒfƒUƒCƒ“M.c‰¡‹æ•ª,TC9–¼ŽhƒfƒUƒCƒ“M.ƒfƒUƒCƒ“,TC9–¼ŽhƒfƒUƒCƒ“M.—\”õ‚ ,TC9–¼ŽhƒfƒUƒCƒ“M.—\”õ‚¢,TC9–¼ŽhƒfƒUƒCƒ“M.—\”õ‚¤,TC9–¼ŽhƒfƒUƒCƒ“M.—\”õ1,TC9–¼ŽhƒfƒUƒCƒ“M.—\”õ2,TC9–¼ŽhƒfƒUƒCƒ“M.—\”õ3 FROM TC9–¼ŽhƒfƒUƒCƒ“M CROSS JOIN TC1ƒVƒXƒeƒ€M WHERE (TC1ƒVƒXƒeƒ€M.ƒfƒtƒHƒ‹ƒgƒtƒ‰ƒO = 1) AND (TC9–¼ŽhƒfƒUƒCƒ“M.ƒVƒXƒeƒ€CD = 'INPORT14')" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TC9–¼ŽhƒfƒUƒCƒ“M WHERE ƒVƒXƒeƒ€CD = 'INPORT14'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TC9•¶‘Ží—ÞM" bcp sj4webdb.dbo.TC9•¶‘Ží—ÞM in TC9•¶‘Ží—ÞM.csv /e TC9•¶‘Ží—ÞM_in_err.txt /c /t ::: /r ;;;\n /S %1 /U sj4user /P sj4 osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "UPDATE TC9•¶‘Ží—ÞM SET ƒVƒXƒeƒ€CD = 'INPORT14'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "INSERT INTO TC9•¶‘Ží—ÞM(ƒVƒXƒeƒ€CD,•¶‘Ží—ÞCD,Ž©“®ƒtƒ‰ƒO,•¶‘–¼Ì,ƒAƒhƒŒƒX,‡˜,—\”õ‚ ,—\”õ‚¢,—\”õ‚¤,—\”õ1,—\”õ2,—\”õ3) SELECT TC1ƒVƒXƒeƒ€M.ƒVƒXƒeƒ€CD,TC9•¶‘Ží—ÞM.•¶‘Ží—ÞCD,TC9•¶‘Ží—ÞM.Ž©“®ƒtƒ‰ƒO,TC9•¶‘Ží—ÞM.•¶‘–¼Ì,TC9•¶‘Ží—ÞM.ƒAƒhƒŒƒX,TC9•¶‘Ží—ÞM.‡˜,TC9•¶‘Ží—ÞM.—\”õ‚ ,TC9•¶‘Ží—ÞM.—\”õ‚¢,TC9•¶‘Ží—ÞM.—\”õ‚¤,TC9•¶‘Ží—ÞM.—\”õ1,TC9•¶‘Ží—ÞM.—\”õ2,TC9•¶‘Ží—ÞM.—\”õ3 FROM TC9•¶‘Ží—ÞM CROSS JOIN TC1ƒVƒXƒeƒ€M WHERE (TC1ƒVƒXƒeƒ€M.ƒfƒtƒHƒ‹ƒgƒtƒ‰ƒO = 1) AND (TC9•¶‘Ží—ÞM.ƒVƒXƒeƒ€CD = 'INPORT14')" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TC9•¶‘Ží—ÞM WHERE ƒVƒXƒeƒ€CD = 'INPORT14'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TDAŠ¨’è‰È–ÚM WHERE ‰‰KCD = 'SYSORIGN'" bcp sj4webdb.dbo.TDAŠ¨’è‰È–ÚM in TDAŠ¨’è‰È–ÚM.csv /e TDAŠ¨’è‰È–ÚM_in_err.txt /c /t ::: /r ;;;\n /S %1 /U sj4user /P sj4 osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "UPDATE TDAŠ¨’è‰È–ÚM SET ƒVƒXƒeƒ€CD = 'INPORT14' WHERE ƒVƒXƒeƒ€CD = 'SFC' AND ‰‰KCD = 'SYSORIGN'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "INSERT INTO TDAŠ¨’è‰È–ÚM(ƒVƒXƒeƒ€CD,‰‰KCD,Š¨’èCD,‹ÆŽíCD,Š¨’è–¼Ì,Š¨’è—ª–¼Ì,Š¨’è‹æ•ª,Š¨’è×–Ú,Š—L‰ïŽÐCD,‘ݎ؋敪,ƒf[ƒ^‹æ•ª,”ï—p‹æ•ª,•ªÍ—p‹æ•ª,ƒ`ƒFƒbƒN‹æ•ª,“Á•ÊŠ¨’è‹æ•ª,WŒv抨’è,WŒv‹æ•ª,”•\WŒvCD,쬋敪,XV“úŽž,—\”õ‚ ,—\”õ‚¢,—\”õ‚¤,—\”õ1,—\”õ2,—\”õ3) SELECT TC1ƒVƒXƒeƒ€M.ƒVƒXƒeƒ€CD,TDAŠ¨’è‰È–ÚM.‰‰KCD,TDAŠ¨’è‰È–ÚM.Š¨’èCD,TDAŠ¨’è‰È–ÚM.‹ÆŽíCD,TDAŠ¨’è‰È–ÚM.Š¨’è–¼Ì,TDAŠ¨’è‰È–ÚM.Š¨’è—ª–¼Ì,TDAŠ¨’è‰È–ÚM.Š¨’è‹æ•ª,TDAŠ¨’è‰È–ÚM.Š¨’è×–Ú,TDAŠ¨’è‰È–ÚM.Š—L‰ïŽÐCD,TDAŠ¨’è‰È–ÚM.‘ݎ؋敪,TDAŠ¨’è‰È–ÚM.ƒf[ƒ^‹æ•ª,TDAŠ¨’è‰È–ÚM.”ï—p‹æ•ª,TDAŠ¨’è‰È–ÚM.•ªÍ—p‹æ•ª,TDAŠ¨’è‰È–ÚM.ƒ`ƒFƒbƒN‹æ•ª,TDAŠ¨’è‰È–ÚM.“Á•ÊŠ¨’è‹æ•ª,TDAŠ¨’è‰È–ÚM.WŒv抨’è,TDAŠ¨’è‰È–ÚM.WŒv‹æ•ª,TDAŠ¨’è‰È–ÚM.”•\WŒvCD,TDAŠ¨’è‰È–ÚM.쬋敪,TDAŠ¨’è‰È–ÚM.XV“úŽž,TDAŠ¨’è‰È–ÚM.—\”õ‚ ,TDAŠ¨’è‰È–ÚM.—\”õ‚¢,TDAŠ¨’è‰È–ÚM.—\”õ‚¤,TDAŠ¨’è‰È–ÚM.—\”õ1,TDAŠ¨’è‰È–ÚM.—\”õ2,TDAŠ¨’è‰È–ÚM.—\”õ3 FROM TDAŠ¨’è‰È–ÚM CROSS JOIN TC1ƒVƒXƒeƒ€M WHERE (TC1ƒVƒXƒeƒ€M.ƒfƒtƒHƒ‹ƒgƒtƒ‰ƒO = 1) AND (TDAŠ¨’è‰È–ÚM.ƒVƒXƒeƒ€CD = 'INPORT14')" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TDAŠ¨’è‰È–ÚM WHERE ƒVƒXƒeƒ€CD = 'INPORT14' AND ‰‰KCD = 'SYSORIGN'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TDA•ñ‘‘Ž®M WHERE ‰‰KCD = 'SYSORIGN'" bcp sj4webdb.dbo.TDA•ñ‘‘Ž®M in TDA•ñ‘‘Ž®M.csv /e TDA•ñ‘‘Ž®M_in_err.txt /c /t ::: /r ;;;\n /S %1 /U sj4user /P sj4 osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "UPDATE TDA•ñ‘‘Ž®M SET ƒVƒXƒeƒ€CD = 'INPORT14' WHERE ƒVƒXƒeƒ€CD = 'SFC' AND ‰‰KCD = 'SYSORIGN'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "INSERT INTO TDA•ñ‘‘Ž®M(ƒVƒXƒeƒ€CD,‰‰KCD,’ •[‹æ•ª,WŒvCD,WŒv–¼Ì,‘ÝŽØ,WŒvæ,‰ÁŒ¸‹æ•ª,ƒ‰ƒCƒ“ƒRƒ“ƒgƒ[ƒ‹,ƒAƒ“ƒ_[ƒ‰ƒCƒ“,‰E•û•\Ž¦,\¬•\Ž¦,쬋敪,XVƒvƒƒOƒ‰ƒ€ID,XV“úŽž,—\”õ‚ ,—\”õ‚¢,—\”õ‚¤,—\”õ1,—\”õ2,—\”õ3) SELECT TC1ƒVƒXƒeƒ€M.ƒVƒXƒeƒ€CD,TDA•ñ‘‘Ž®M.‰‰KCD,TDA•ñ‘‘Ž®M.’ •[‹æ•ª,TDA•ñ‘‘Ž®M.WŒvCD,TDA•ñ‘‘Ž®M.WŒv–¼Ì,TDA•ñ‘‘Ž®M.‘ÝŽØ,TDA•ñ‘‘Ž®M.WŒvæ,TDA•ñ‘‘Ž®M.‰ÁŒ¸‹æ•ª,TDA•ñ‘‘Ž®M.ƒ‰ƒCƒ“ƒRƒ“ƒgƒ[ƒ‹,TDA•ñ‘‘Ž®M.ƒAƒ“ƒ_[ƒ‰ƒCƒ“,TDA•ñ‘‘Ž®M.‰E•û•\Ž¦,TDA•ñ‘‘Ž®M.\¬•\Ž¦,TDA•ñ‘‘Ž®M.쬋敪,TDA•ñ‘‘Ž®M.XVƒvƒƒOƒ‰ƒ€ID,TDA•ñ‘‘Ž®M.XV“úŽž,TDA•ñ‘‘Ž®M.—\”õ‚ ,TDA•ñ‘‘Ž®M.—\”õ‚¢,TDA•ñ‘‘Ž®M.—\”õ‚¤,TDA•ñ‘‘Ž®M.—\”õ1,TDA•ñ‘‘Ž®M.—\”õ2,TDA•ñ‘‘Ž®M.—\”õ3 FROM TDA•ñ‘‘Ž®M CROSS JOIN TC1ƒVƒXƒeƒ€M WHERE (TC1ƒVƒXƒeƒ€M.ƒfƒtƒHƒ‹ƒgƒtƒ‰ƒO = 1) AND (TDA•ñ‘‘Ž®M.ƒVƒXƒeƒ€CD = 'INPORT14')" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TDA•ñ‘‘Ž®M WHERE ƒVƒXƒeƒ€CD = 'INPORT14' AND ‰‰KCD = 'SYSORIGN'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TC2‰‰KM WHERE ƒVƒXƒeƒ€CD = 'INPORT14'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TC1ƒVƒXƒeƒ€M WHERE ƒVƒXƒeƒ€CD = 'INPORT14'" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TC2‰‰KM WHERE ƒVƒXƒeƒ€CD = 'SFC' AND EXISTS(SELECT * FROM TC1ƒVƒXƒeƒ€M WHERE ƒVƒXƒeƒ€CD = 'SFC' AND ƒfƒtƒHƒ‹ƒgƒtƒ‰ƒO = 0)" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -Q "DELETE FROM TC1ƒVƒXƒeƒ€M WHERE ƒVƒXƒeƒ€CD = 'SFC' AND ƒfƒtƒHƒ‹ƒgƒtƒ‰ƒO = 0" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m1 -Q "exec SPM‹L’ ƒ`ƒFƒbƒN‘}“üWŒvXV‘S•”" osql -S %1 -U sj4user -P sj4 -d sj4webdb -m0 -i •ñ‘‘Ž®ŠÇ—‚̕⊮.sql