<div>
Hi, 
 
Check this. 

<pre><code class="code-1 nolinks" id="code-1353701">Select 
	[Enquiry_ID],
	(Stuff((Select ', ' + ENQ_FU_COMMENT From tblEnquiry_Follow_Up E2 Where E1.Enquiry_ID = E2.Enquiry_ID FOR XML PATH('')),1,2,'')) as ENQ_FU_COMMENT
From tblEnquiry E1
Order By Enquiry_ID
</code></pre>
</div>

<div>
For Sample 

<pre><code class="code-10 nolinks" id="code-1353723">Declare @Aliases Table
(
	[FirstName] varchar(50) not null,
	[LastName] varchar(50) not null,
	[Alias] varchar(100) not null
)

Insert @Aliases
Select 'Clark','Kent','Superman'
Union All
Select 'Clark','Kent','Kal-El'
Union All
Select 'Clark','Kent','Gangbuster'
Union All
Select 'Clark','Kent','Supernova'
Union All
Select 'Clark','Kent','Nightwing'
Union All
Select 'Peter','Parker','Spiderman'
Union all
Select 'Peter','Parker','WebSligner'

Select * from @Aliases

Select Distinct
	[LastName],
	[FirstName],
	(Stuff((Select ', ' + Alias From @Aliases T2 Where T2.FirstName = T1.FirstName and T2.LastName = T2.LastName FOR XML PATH('')),1,2,'')) as Aliases
From @Aliases T1
Order By [LastName], [FirstName]
</code></pre>
</div>

<div>
<div class="content wysiwyg-content">
I have 2 tables 
1. tblENQUIRY and 
2. tblENQUIRY_FOLLOW_UP 
 
The history contains the PK ENQUIRY_ID from the &nbsp;tblENQUIRY 
 
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2010/11_w46/368999/EE-1.png" target="_blank" title="tblENQUIRY (8 KB)"><img alt="tblENQUIRY" class="file-block lazyload" style="max-width: 398px;" data-src="https://filedb.experts-exchange.com/incoming/2010/11_w46/368999/EE-1.png" /></a> <a href="https://filedb.experts-exchange.com/incoming/2010/11_w46/369000/EE-2.png" target="_blank" title="tblENQUIRY_FOLLOW_UP (11 KB)"><img alt="tblENQUIRY_FOLLOW_UP" class="file-block lazyload" style="max-width: 384px;" data-src="https://filedb.experts-exchange.com/incoming/2010/11_w46/369000/EE-2.png" /></a> <a href="https://filedb.experts-exchange.com/incoming/2010/11_w46/369002/EE-3.png" target="_blank" title="SAMPLE DATA IN FOLLOW UP (30 KB)"><img alt="SAMPLE DATA IN FOLLOW UP" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2010/11_w46/800_369002/EE-3.png" /></a> 
What I need to do is create a new table with the 2 columns 
ENQUIRY_ID and ENQ_FU_COMMENT 
 
for each ENQUIRY_ID concatenate all of the individual lines in just one line. 
 
like this ... 
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2010/11_w46/369007/ee-5.png" target="_blank" title="what it should look like (18 KB)"><img alt="what it should look like" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2010/11_w46/800_369007/ee-5.png" /></a> 
I really appreciate help on this. 
 
My solution does not work correctly. 
 
best regards
</div>
</div>

ee-5.png

EE-3.png

EE-1.png

EE-2.png

I have 2 tables 
1. tblENQUIRY and 
2. tblENQUIRY_FOLLOW_UP

The history contains the PK ENQUIRY_ID from the  tblENQUIRY

   

What I need to do is create a new table with the 2 columns 
ENQUIRY_ID and ENQ_FU_COMMENT

for each ENQUIRY_ID concatenate all of the individual lines in just one line.

like this ...
 

I really appreciate help on this.

My solution does not work correctly.

best regards

How to concatenate entries?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.