Dear all,
I need to update one field in a table for a given record and visit number.
Example below is how the table looks -
SID VISIT DLCO
101 0 12
101 1 16
102 0 18
102 2 10
103 1 12
103 2 14
Here is how I would like it to look. The changes are the starred items.
SID VISIT DLCO
101 0 14*
101 1 16
102 0 18
102 2 16*
103 1 12*
103 2 14
I know it is an UPDATE statement, but I am not sure how to use it when I
need to update more than one record.
Thanks for the help in advance.
Jeff