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.
but i see i need to add a where statement in the inner select somehow to match the patients.
update #Patients set LatestVisit = h.VisitDate, Id = h.id from (select top 1 fd.PersonId, fd.id, fd.VisitDate from dbo.Trombos_FollowUpData fd order by fd.Visitdate desc ) h where h.Personid = #Patients.PersonId
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.