Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!