Name

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

Synopsis

int rebuild_ranks_grp_rnktype ( grp,  
  rnktype);  
NUMERIC(6,4) grp ;
varchar(6) rnktype ;
 

Input

grp

A GROUPS.Gid.

rnktype

A RNKTYPES.Rnktype.

Description

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

Note

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

Example

SELECT rebuild_ranks_grp_rnktype(1.0000, 'ALM');


Page generated: 2025-03-10T16:52:07-04:00.