title: How to add holidays to DimTime table?
body: <p>I require to add the a holiday indicator in my DimTime table. I have already added a HolidayInd column which I need to update with the specific information. I also have a Holidays table which includes the holidays.</p>
  <p>My current DimTime table (10 row sample). Full table goes from 1900 to 2050.</p>
  <pre><code>idDimTime FullTime      HolidayInd
  20000101  2000-01-01    NULL
  20000102  2000-01-02    NULL
  20000103  2000-01-03    NULL
  20000104  2000-01-04    NULL
  20000105  2000-01-05    NULL
  20000106  2000-01-06    NULL
  20000107  2000-01-07    NULL
  20000108  2000-01-08    NULL
  20000109  2000-01-09    NULL
  200001010 2000-01-10    NULL
  </code></pre>
  <p>My Holidays table (5row sample). I contains all the holidays between years 2000 and 2050</p>
  <pre><code>id idDimTime
  1  20000101
  2  20000110
  3  20000320
  4  20000420
  5  20000421
  </code></pre>
  <p>My DimTime desired table</p>
  <pre><code>idDimTime FullTime    HolidayInd
  20000101  2000-01-01    1
  20000102  2000-01-02    0
  20000103  2000-01-03    0
  20000104  2000-01-04    0
  20000105  2000-01-05    0
  20000106  2000-01-06    0
  20000107  2000-01-07    0
  20000108  2000-01-08    0
  20000109  2000-01-09    0
  200001010 2000-01-10    1
  </code></pre>
  <p>I have joined both tables but unsure on how to update DimTime based on it</p>
  <pre><code>SELECT  
  DT.IdDimTime
  ,CASE WHEN H.IdDimTime IS NULL THEN 0
          ELSE 1
          END AS HolidayInd
  FROM DimTime DT
  
  LEFT JOIN Holidays H
  ON H.IdDimTime = DT.IdDimTime
  WHERE DT.IdDimTime BETWEEN 20000101 AND 20501231
  ORDER BY DT.IdDimTime 
  </code></pre>