title: history of changes to a column
body: <p>Please, consider the following scenario.
  There are 2 tables: Core and History. Core looks as follows</p>
  <hr />
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th></th>
  <th></th>
  <th></th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>HWDateStart</td>
  <td>HWDateEnd</td>
  <td>HWQueueID</td>
  </tr>
  <tr>
  <td>2022-05-29 10:00:00</td>
  <td>2022-06-04 00:45:00</td>
  <td>WIN-S671INNTGRE.P00-K0-01</td>
  </tr>
  <tr>
  <td>2022-05-29 10:00:00</td>
  <td>2022-06-04 00:45:00</td>
  <td>WIN-S671INNTGRE.P00-K0-02</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>History looks as follows</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th></th>
  <th></th>
  <th></th>
  <th></th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>cntDatetime</td>
  <td>cntSerialNumber</td>
  <td>cntQueueName</td>
  <td>cntQueueID</td>
  </tr>
  <tr>
  <td>2022-05-29 02:28:00</td>
  <td>SN01-01</td>
  <td>p00-0000-01</td>
  <td>WIN-S671INNTGRE.P00-K0-01</td>
  </tr>
  <tr>
  <td>2022-05-29 02:28:00</td>
  <td>SN02-01</td>
  <td>p00-0000-02</td>
  <td>WIN-S671INNTGRE.P00-K0-02</td>
  </tr>
  <tr>
  <td>2022-06-04 00:26:00</td>
  <td>SN02-02</td>
  <td>p00-0000-02</td>
  <td>WIN-S671INNTGRE.P00-K0-02</td>
  </tr>
  <tr>
  <td>2022-06-04 00:26:00</td>
  <td>SN01-01</td>
  <td>p00-0000-01</td>
  <td>WIN-S671INNTGRE.P00-K0-01</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>History holds a list of cntSerialNumber changes through the time
  The following script that gives the user SerialNumber as it was at the beginning and the end of a certain period</p>
  <pre><code>    SELECT Convert(date,[HWDateStart]) 
        ,Convert(date,[HWDateEnd]) 
        ,[HWQueueID]
        , HS.cntSerialNumber
        , HE.cntSerialNumber
    FROM [watchdocstats].[dbo].[tblJT] SNTarget,
    [watchdocstats].[dbo].[tblQueueByConfig] HS,
    [watchdocstats].[dbo].[tblQueueByConfig] HE
      WHERE 
          SNTarget.HWQueueID      = HS.cntQueueID
    AND   SNTarget.HWQueueID      = HE.cntQueueID
    AND   Convert(date,SNTarget.HWDateStart) = Convert(date,HS.cntDatetime)
    AND   Convert(date,SNTarget.HWDateEnd) = Convert(date,HE.cntDatetime)
  </code></pre>
  <p>But what if SerialNumber has been changed more than once down the road
  Is there a way to select a table that would show commaseparated SerialNumbers in cntSerialNumber column?
  Smth, like</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th></th>
  <th></th>
  <th></th>
  <th></th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>(Start)</td>
  <td>(End)</td>
  <td>HWQueueID</td>
  <td>cntSNHist</td>
  </tr>
  <tr>
  <td>2022-05-29</td>
  <td>2022-06-04</td>
  <td>WIN-S671INNTGRE.P00-K0-01</td>
  <td>SN01-01</td>
  </tr>
  <tr>
  <td>2022-05-29</td>
  <td>2022-06-04</td>
  <td>WIN-S671INNTGRE.P00-K0-02</td>
  <td>SN02-01,SN02-02,SN02-03</td>
  </tr>
  </tbody>
  </table>
  </div>