WITH car_code AS
(
SELECT '0001' code, '차량1' name
UNION ALL SELECT '0002', '차량2'
UNION ALL SELECT '0003', '차량3'
UNION ALL SELECT '0004', '차량4'
)
, car_order AS
(
SELECT 'ord0001' order_code, '0001' car_code, '2022-10-01' start_date, '2022-10-03' end_date
UNION ALL SELECT 'ord0002', '0001', '2022-10-15', '2022-10-18'
UNION ALL SELECT 'ord0003', '0001', '2022-11-05', '2022-11-07'
UNION ALL SELECT 'ord0004', '0002', '2022-10-16', '2022-10-17'
UNION ALL SELECT 'ord0005', '0002', '2022-10-03', '2022-10-03'
)
, calendar AS
(
SELECT DATEADD(day, 0, '2022-11-01') dt
 UNION ALL
SELECT DATEADD(day, 1, dt) dt
  FROM calendar
 WHERE dt < DATEADD(day, -1, DATEADD(month, 1, '2022-11-01'))
)
SELECT *
  FROM (SELECT a.code
             , a.name
             , d.d
             , d.v
          FROM car_code a
          LEFT OUTER JOIN
               (SELECT c.car_code
                     , DAY(b.dt) d
                     , '완료' v
                  FROM calendar b
                 INNER JOIN car_order c
                    ON b.dt BETWEEN c.start_date AND c.end_date
                ) d
            ON a.code = d.car_code
        ) e
 PIVOT (MIN(v) FOR d
    IN (  [1],  [2],  [3],  [4],  [5],  [6],  [7],  [8],  [9], [10]
       , [11], [12], [13], [14], [15], [16], [17], [18], [19], [20]
       , [21], [22], [23], [24], [25], [26], [27], [28], [29], [30]
       , [31] )) f
;