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.
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
Join the community of 500,000 technology professionals and ask your questions.