Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Select *,STUFF(( SELECT ' ' + CC.[First Name] + ' ' + CC.[Last Name] + '-' + B.Notes + CHAR(10) FROM dbo.[Client Contact Events] AS B INNER JOIN dbo.[Client Contacts] CC ON B.[Contact ID] = CC.[Contact ID] WHERE [CVT].[Client ID] = B.[Client ID] AND B.EventType = 'Visit' AND B.[Contact Date] > [CVT].createdDate FOR XML PATH ('')),1,0,'') AS [Contact Notes] From mytable
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.