title: Concatenating SELECT into one column in SQL Server
body: <p>I really did pore over all of the various things posted on this, but I can't get any of them to work, possibly because the table I'm using has no kind of identity column (stupid, stupid, stupid!).</p>
  
  <p>I have a list of all people who are contacts associated with a lease in a column called <code>file_as_name</code>. The table is called <code>lease_contacts</code> unsurprisingly.</p>
  
  <p>In another table, I have a large character column into which I need to stuff the concatenated results, when the table is is grouped by "name, unit, lease_start_date".</p>
  
  <p>In other words, for a group at a property named "Cedar Villas" and "Unit 001" and Lease_start_date = "01/01/2019", I have these values:</p>
  
  <pre><code>John Doe
  Jane Smith
  Allen Smithee
  </code></pre>
  
  <p>In the column, I want to place:</p>
  
  <pre><code>John Doe, Jane Smith, Allen Smithee
  </code></pre>
  
  <p>Is this possible?  I think it is, but the grouping by three columns is killing me.</p>