SELECT 운용사펀드코드, (SELECT 설정일 FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=D:\20170703\설정일생성.xlsx;','SELECT * FROM [Sheet1$]') WHERE 펀드코드 = A.운용사펀드코드) AS 설정일 FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=D:\20170703\펀드설정전체.xlsx;','SELECT * FROM [Sheet1$]') A ----------------------------------------------- 기본셋팅 1. Ad Hoc Distributed Queries 옵션 활성화 EXEC sp_config..

UPDATE TB_MARKETING AA SET (AGENCY_ID) = (SELECT AGENCY_ID FROM TEMP_GROUP B WHERE B.GROUP_NAME =AA.GROUP_NAME) SELECT E.ID, E.SUBID, T.SUBID UPDATE TB_MARKETING SET SUBID = T.SUBID FROM TB_MARKETING E INNER JOIN #TEMP_GROUP T ON ( E.SEQ = T.SEQ )

-- MERGE UPDATE MERGE INTO IFT_FUND_STANDARD_PRICE_RESULT A USING ( SELECT TIMS_DATE,FUND_CODE,BM_INDEX,BM_RATE FROM IFT_FUND_STANDARD_PRICE_RESULT WHERE FUND_CODE ='10110' AND TIMS_DATE > '20130115' ) B ON ( A.TIMS_DATE = B.TIMS_DATE AND A.FUND_CODE ='10112' ) WHEN MATCHED THEN UPDATE SET A.BM_INDEX = B.BM_INDEX, A.BM_RATE = B.BM_RATE ============================================================..