I need assistance with an update script (cursor).
Basically, what I have is an entry in one table that I need one another table. What is currently found on the PatientVisit.Note field, I need copied and placed into the PatientCorrespondence.Desc
The data types are as follows:
PatientVisit.Notes - Text
ription - VARCHAR(255)
The PatientVisitId is FK relationship back to the PatientVisit table from the PatientCorrespondence table.
I will need to do an insert into my PatientCorrespondence table where the patientvisitIds match and insert the value that was in my patientvisit.notes into the description below.
INSERT INTO dbo.PatientCorrespondence