달력 테이블을 만들어 조인에 실패한 자료를 찾아보세요.
WITH calendar AS ( -- 달력만들기 -- SELECT '2000-01-01' dt -- 시작일자 UNION ALL SELECT CONVERT(VARCHAR(10), DATEADD(day, 1, dt), 23) FROM calendar WHERE dt < '2017-12-31' -- 종료일자 ) , data_t AS ( -- 원본 데이터 -- SELECT '2016-06-31' createDay UNION ALL SELECT '2016-06-30' ) SELECT a.createDay FROM data_t a LEFT OUTER JOIN calendar b ON a.createDay = b.dt WHERE b.dt IS NULL OPTION (MAXRECURSION 0) ;