title: Read Top 10 ROWS from a table in one database and insert the concatenated results into a single column on another database
body: <p>I am trying to create a metadata table on one database providing information about the tables on a database.  The goal is to show example data (top 10) for the each row in a table within a single column on the metadata table. </p>
  
  <p>Example:  </p>
  
  <p><strong>Data Source</strong>  on SQL Server "Source System"</p>
  
  <pre><code>╔════╦═══════════════════╗
  ║ ID ║   Name            ║
  ╠════╬═══════════════════╣
  ║ 1  ║  John             ║
  ║ 2  ║  Jane             ║
  ║ 3  ║  Joe              ║
  ║ 4  ║  Jimmy            ║
  ╚════╩═══════════════════╝
  </code></pre>
  
  <hr>
  
  <p><strong>Metadata Table</strong> on SQL Server "Metadata"</p>
  
  <pre><code>╔═══════╦═════════════════════════╗
  ║ Col   ║         Example         ║
  ╠═══════╬═════════════════════════╣
  ║ ID    ║  1, 2, 3, 4             ║
  ║ Name  ║  John, Jane, Joe, Jimmy ║
  ╚═══════╩═════════════════════════╝
  </code></pre>
  
  <p>Any suggestions?  Pivot seems to move the rows to columns where as I need many rows to just one column.</p>