<div>
This looks good. &nbsp;Can you please tell me, though, where do I enter the function? (I haven't used functions in MSSQL before). I work with both MS Access &amp;&nbsp;enterprise manager.<br />
<br />
Thanks.
</div>


This looks good.  Can you please tell me, though, where do I enter the function? (I haven't used functions in MSSQL before). I work with both MS Access & enterprise manager.

Thanks.

<div>
navigate to user-defined functions in EM. &nbsp;Create New Function. &nbsp;Copy/Paste the code above in and save it. &nbsp;Feel free to change names/datatypes as appropriate.
</div>


navigate to user-defined functions in EM.  Create New Function.  Copy/Paste the code above in and save it.  Feel free to change names/datatypes as appropriate.

<div>
I entered your code (customizing for my actual data structures) and it worked perfectly. &nbsp;Thank you very much for your fast and accurate answer!
</div>


I entered your code (customizing for my actual data structures) and it worked perfectly.  Thank you very much for your fast and accurate answer!

<div>
<div class="content wysiwyg-content">
I have a parent-child relationship between two tables. &nbsp;I need to create a new view for exporting for use in a spreadsheet or a word processor. This view needs to have all the related child records combined into one field and included in the parent record of this new, flattened table.<br />
<br />
More specifically, the tables are books (parent) and authors (child). &nbsp;We can have multiple authors for each book. &nbsp;I want to end up with a table/view/query listing book titles in one field, and ALL author names in another field. The author names should be separated by a comma and space (if we can't get rid of the last comma, that isn't such a problem).<br />
<br />
Thank you.
</div>
</div>


I have a parent-child relationship between two tables.  I need to create a new view for exporting for use in a spreadsheet or a word processor. This view needs to have all the related child records combined into one field and included in the parent record of this new, flattened table.

More specifically, the tables are books (parent) and authors (child).  We can have multiple authors for each book.  I want to end up with a table/view/query listing book titles in one field, and ALL author names in another field. The author names should be separated by a comma and space (if we can't get rid of the last comma, that isn't such a problem).

Thank you.

Combine child records into flat table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.