Execute the following script in Query Editor to concatenate the last names of AdventureWorks employees:

USE AdventureWorks;

select [Concatenated Last Names ]=
replace(replace((
select distinct LastName as [AllLastNames]
from Person.Contact c
join HumanResources.Employee e
on e.ContactID = c.ContactID
for xml path('')),
'<AllLastNames>', ''),'</AllLastNames>','')

GO