SELECT DISTINCT H.HolidayId,H.HolidayDate,H.Description,CH.ClientId,
        case when CH.HolidayId is not null then 1 else 0 end as  IsHoliday
        FROM Holiday H LEFT JOIN ClientHolidays CH ON h.HolidayId = CH.HolidayId