July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.
Select blah, blah, STUFF(( SELECT ' ' + CC.[First Name] + ' ' + CC.[Last Name] + '-' + B.Notes + CHAR(10)+ 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.