Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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