Read Top 10 ROWS from a table in one database and insert the concatenated results into a single column on another database
How to concatenate text from multiple rows into a single text string in SQL server?