Re: Passing value beteen declared variables within cursor loop

[Michael Ayres]

Some query statements might work, but somehow i have to capture a field value and insert it into any following (one or more) records with a null in same field. Then, when I encounter a record with a value already in the field, I need to capture it and insert into any following empty records.

The data looks like this

field1 id
foo1 21
foo2 --
foo3 --
foo4 --
foo5 33
foo6 --
foo7 --
....
so I need to update foo2, foo3, foo4 to 21, and then update foo6, foo7 to 33

etc through the table

Michael Ayres
Senior Technical Project Manager
Cyber Security Coordination Center

Michael Ayres, MS, PMP, ACP, CISSP
University of California Office of the President (contractor)
1111 Franklin Street #7109 Oakland, Ca.94607
[e-mail] | [phone] | [phone] Mobile