title: SQL: How to update column values from a specific Select with a Windowed Function (stuff, dense rank, over)
body: <p>This is what I would like to do:</p>
  <pre><code>UPDATE TableA
  SET ColumnA = SELECT stuff(ColumnA, 1, 2, 11+dense_rank() over(order by left(ColumnA, 10))) from TableA
  WHERE Year = '2021'
  AND Type = 'LA'
  </code></pre>
  <p>I would like to set a column's values to the values of that SELECT</p>