CREATE TABLE #SETTLE_DAILY (
TARGET_DATE VARCHAR(10) NOT NULL ,
TOT_CNT INT DEFAULT NULL ,
TOT_PRECNT INT DEFAULT NULL ,
TOT_GOCNT INT DEFAULT NULL ,
TOT_PRICE INT DEFAULT NULL ,
TOT_PREPRICE INT DEFAULT NULL ,
TOT_GOPRICE INT DEFAULT NULL
)
CREATE TABLE #SETTLE_CHK (
TARGET_DATE VARCHAR(10) NOT NULL
)
-- 임시 테이블 삭제
DROP TABLE #SETTLE_DAILY
DROP TABLE #SETTLE_CHK
Posted by 홍반장
