Community Trekker

Re: ColumnRank by group?

Thanks Ron.

Finally, I chose to modify the original update script. It's a 3 steps procedure:

  1. The first step is the original update (ODBC data source) which is creating a new table (because of the hard code columns);
  2. Then a second script step is updating my main table with this new table's data;
  3. The last step is closing the new table.

This way I can to create as many new hard code columns as I need (the script won't need any fix).