I inherited a table with 800+ fields, many of which have little or no data.
I would like to write a script which iterates through all the fields in this table, writing a record to another table with two fields:
-- field name
-- number of records having a non-empty value in that field
How should I perform the calculation in red?
One approach would consist of constructing a find on each field, but I don't know how to write a dynamic find.