select
'Historical Sprout Note' as Title
,p.EmrID as GreenwayId
,Stuff( (Select Concat(N2.Details, ' : ', u.FirstName, ' ', u.LastName, ' ', TRY_CONVERT(nvarchar(127), n2.[CreatedOn]))
FROM Notes n2
Join UserProfiles u on u.id = n1.CreatedBy
For XML PATH('') , Type).value('.', 'varchar(max)'),1,1,'')
From
Notes as n1
JOIN Patients as p ON
    p.Id = n1.PatientId
    Group by p.EmrID