rebuild_ranks

rebuild_ranks
Prev	Data Analysis Procedures	Next

Name

rebuild_ranks — rebuild the calculated columns in RANKS for all rows with a specific Grp, Rnkdate, and Rnktype


                  NUMERIC(6,4)
                  grp

;


                  date
                  rnkdate

;


                  varchar(6)
                  rnktype

;

A date.

This procedure rebuilds the Ags_Density, Ags_Reversals, and Ags_Expected columns for all rows in RANKS with the specified Grp, Rnkdate, and Rnktype. The INTERACT_DATA, PARTS, and RANKS tables provide the data necessary to rebuild these columns.

These columns are not automatically maintained by the system at this time.

SELECT rebuild_ranks(1.0000, '2003-02-01', 'ALM');

Prev	Up	Next
rebuild_all_mmintervals	Home	rebuild_ranks_grp_rnktype